Help Table of Contents

Client Help

  1. User Types and Roles
  2. Pro User
    1. Pro Workflow Overview
    2. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
            1. Context Menu Configuration
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
          3. Chat Search in your Hub
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Quick Open
        3. App Tab Manager
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. App Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
          1. Dynamic Clipboard Tools
        3. Text Formatting
        4. Saving Content
          1. Assigning Content Access
        5. Print and Export
          1. Printing from Embedded Content
        6. Subscriptions
          1. Configure Subscriptions
        7. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
        8. Data Source Authentication
    3. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    4. Pro Apps
      1. Model
        1. Data Modeling Overview
          1. Data Modeling Concepts
            1. Model Files vs Deployed Models
            2. External Models vs Pyramid Models
            3. Data Flows vs Semantic Models
          2. Smart Modeling
            1. New Smart Model
            2. Smart Modeling Heuristics
            3. Manage Smart Models
              1. Open And Edit Smart Models
              2. Save Smart Models
              3. Secure Smart Models
              4. Rerun Smart Models
          3. Model Lite
            1. New Lite Model
              1. Target
              2. Data
              3. Tables
              4. Columns
              5. Hierarchies
              6. Finish and Build
              7. Model Lite Heuristics
            2. Manage Lite Models
              1. Open Edit Lite Models
              2. Save Lite Models
              3. Rerun Lite Models
          4. Direct Model
            1. Servers
            2. Schema Display
            3. Relationships and Joins
            4. Managing Direct Models
              1. Save a Direct Model
              2. Open and Edit a Direct Model
              3. Process a Direct Model
              4. Rerun Direct Models
          5. Model Pro
            1. Model Pro Examples
            2. Master Flow
              1. Master Flow Interface
              2. General Nodes
                1. Data Flow
                2. SQL Script
                3. Data Model
                4. Set Variable
                5. Rest APIs
                6. Pyramid Event
                7. Command Line Support
                8. On Demand Schedules
                9. Wait
              3. Looping Steps
                1. For Loop
                2. For Each Loop
                3. While Loop
              4. Conditional
                1. Conditional Node
                2. Switch Statement
              5. Messaging
                1. Email
                2. SMS
              6. Master Flow Validation
            3. Data Flow
              1. Data Flow Interface
                1. Data Flow Ribbon
                2. Properties
                3. Node Selection
                4. Datasource Preview
                  1. Column Statistics
                5. Variables
                  1. Variables Panel
                  2. SQL Variables Vs Static Variables
                  3. Incremental Loading
                  4. Inject Variables
                6. Workspace Layout
                7. Split Nodes
              2. Sources
                1. Data Sources and Targets
                2. Direct Query vs Ingested Data
                3. Use Existing Semantic Model
                4. File Sources
                  1. Pyramid Content: Discover
                    1. Pyramid Content: Tabulate
                  2. Access File Source
                  3. Excel
                  4. Google Sheets
                  5. JSON File Source
                  6. Multi Files
                  7. Parquet File Source
                  8. SAS Data Set Source
                  9. Text File Sources
                  10. XML File Source
                5. Relational Sources
                  1. Pyramid In Memory Database
                  2. SAP HANA Datasource
                6. BigData Sources
                  1. Adding Big Query as a Data Source
                  2. MongoDb Datasource
                7. Cloud Sources
                  1. Amazon S3
                  2. Azure Blob
                  3. Box
                  4. Facebook Data Source
                  5. Google Analytics (GA4)
                  6. Google Drive
                  7. RSS
                  8. SalesForce
                  9. SharePoint
                  10. SFTP (SSH) and FTP
                  11. X (Twitter) Data Source
                8. Other Sources
                  1. ODBC
                  2. ODBC Direct
                  3. OData source
                  4. Date Range Source
                  5. Scripted Sources
                    1. Python Source
                    2. R Source
              3. Data Flow Targets
                1. Target Tables
                2. Pyramid IMDB
                3. File Targets
                  1. Amazon S3
                  2. Azure Blob
                  3. Box
                  4. CSV
                  5. Excel
                  6. Google Drive
                  7. Parquet
                  8. SFTP (SSH) and FTP
                  9. Folder Path Expression
                4. Relational Targets
                  1. Custom Target Schema
                  2. Execute a Script
                5. Big Data and Unstructured Targets
              4. Select
                1. Query
                2. Table
                3. Multi Tables
                4. Bottom N
                5. Top N
              5. Preparation Elements
                1. Add Date/Time
                2. Add Sequence
                3. Date Range
                4. Distinct
                5. Filter
                6. GeoCode
                7. Materialized Masking
                8. Modify Case
                9. Pivot
                10. Random Number
                11. Remove Duplicates
                12. Sort
                13. Summarize
                14. Time Intelligence
                15. Unpivot
              6. Gen-AI
                1. LLM General
                2. LLM Translate
                3. LLM Sentiment
              7. Column Operations
                1. Calculated Columns
                  1. Custom Column PQL Editor
                2. Combined Columns
                3. Convert Columns
                4. JSON Extract
                5. Rename Columns
                6. Reorder Columns
                7. Split Columns
                8. Add Date Unit
                9. Date Difference
                10. Replace
                11. String Left
                12. String Right
                13. Substring
                14. Trim
                15. Aggregate FX
                16. Math FX
                17. Trig FX
              8. Joins
                1. Merge Join
                2. Union Join
              9. Machine Learning
                1. Machine Learning Functions
                  1. Decision Tree
                  2. Naïve Bayes
                  3. Regression Trees
                2. Tensor Flow
                3. Machine Learning Nodes
                4. Machine Learning Examples
              10. Scripting
                1. Scripting Mechanics
                  1. Scripting Inputs and Outputs
                    1. Data Frame Support
                  2. Learn and Predict Scripts
                    1. Python Learn and Predict Examples
                  3. Save Machine Learning Models
                  4. Generate Your Script
                    1. Explain Script
                  5. Marketplace
                    1. Marketplace Scripts
                      1. Sentiment Analysis Example
                      2. Basket Analysis Example
                  6. Shared Scripts
                  7. Virtual Scripting Environments
                2. Python Scripting
                3. R Scripting
              11. Validate Data Flow
              12. Model Transfer Cleanup
            4. Data Modeling
              1. Model Ribbons
                1. Configuration Ribbon
                2. Tables Ribbon
                3. Columns Ribbon
                4. Hierarchy Ribbon
              2. Configuration
                1. MS Tabular Models
                2. Auto Indexing
                3. Query Caching
              3. Tables Panel
                1. Semantic Model and Relationships
                  1. SQL Schema Models
                2. Relationship Table Editor
                3. Sync Settings
                4. Connector Types
                5. Context Menus and Properties
                6. Auto Table Update
                7. Automatic Column Handling
                8. Joins
                  1. Heuristics
                  2. Join Keys
                  3. Bidirectional Joins
                  4. Join Validation
                9. Columns
                  1. Column Visibility
                  2. Column Description
                  3. Data Catalog
                  4. Column Folders
                  5. Column Categories
                  6. Dynamic Data Masking
                10. Measures
                  1. Measure Types
                    1. Cumulative Measure
                    2. Semi Additive Measures
                  2. Measure Formats
                  3. Measure Folders
                  4. Measure Descriptions
                  5. Multi-Measures
                  6. Measure Editor
                  7. Units and Currency
                11. Primary Keys and Indexing
                12. Special Tables and Columns
                  1. Aggregate Tables
                  2. Security Tables and Columns
                  3. Distribution Tables and Columns
                  4. Add Custom Query Table
              4. Columns
                1. Column Configuration
                  1. Configure Custom Maps
                2. Multi-Measures Panel
                3. Column Sorting
                4. Virtual Column Calculations
                  1. Calculated Columns Panels
                  2. Calculated Columns Settings
                  3. Calculated Column Walkthrough
              5. Hierarchy Panel
                1. Hierarchy Panel Mechanics
                  1. Hierarchy Metadata
                  2. Ragged Hierarchies
                  3. Parent Child Hierarchies
                    1. Build Parent Child Hierarchies
                    2. Parent Child Hierarchy Examples
              6. Translations Panel
                1. Translations Attribute
            5. Model Processing
              1. Quick Discovery
              2. Schedule a Data Model
              3. Node Execution Status
              4. Progress Panel
            6. Security
              1. Security Settings
              2. Data Source Management
            7. Model Management
              1. Open and Edit a Model
              2. Save Models
              3. Printing and Documentation
        2. Decision Modeling Overview
          1. Decision Nodes
          2. User Tasks
          3. Building a Decision Flow
      2. Discover
        1. Viewing Discover Content
        2. Natural Language Querying
          1. Accessing NLQ in Discover
          2. NLQ Chatbot
          3. Example: Build a Visual using the Chatbot
          4. Writing NLQ Questions
            1. NLQ: Advanced Intelligence
            2. NLQ: Visualizations
          5. Managing NLQ Discoveries
        3. Smart Discover
          1. Access Smart Discover
          2. Smart Discover Workspace
            1. Item Selection Bar
            2. Visualization Picker
              1. Smart Visualization Mechanics
            3. Design Panel
          3. Build Smart Discoveries
            1. Values
            2. Dimensions
              1. Custom Selections
              2. Sort and Filter Hierarchies
              3. Working with Dates
                1. Date-Time Calculations
                2. Date Parts
            3. Data Filters
            4. Visualizations
              1. Quick Styles
                1. Quick Styles
                2. Quick Styles for Grids
                3. Quick Styles for Cartesian Charts
                4. Quick Styles for Segment Charts
                5. Quick Styles for Plotted Charts
                6. Quick Styles for Maps
          4. Manage Smart Discoveries
            1. Save and Share
        4. Discover Lite
          1. Access Discover Lite
          2. Discover Lite Workspace
            1. Drop Zones
            2. Discover Lite Ribbon
              1. Axis Options
              2. Data Labels
              3. Data Points
              4. Grid Lines
              5. Bookmarks
            3. Model Metadata and Trees
            4. App Tabs Menus
          3. Build Visuals in Discover Lite
            1. Drop Zones
            2. Toolbox
              1. Quick Styles
            3. Dynamic Interactions
              1. Quick Sort Wizard
            4. Quick Calculations
            5. Context Calculations
            6. Running Queries
          4. Manage Visuals in Discover Lite
          5. Conversations
        5. Discover Pro
          1. Access Discover Pro
            1. Pyramid Models
              1. Direct Model on a Database
              2. Direct Model with SQL
            2. Microsoft Models
            3. SAP Models
              1. SAP HANA Views
              2. SAP BW Models
          2. Discover Pro Workspace
            1. Discover Pro Ribbons
              1. Panel Layout
            2. Data Model Trees
              1. Dimensions and Hierarchies
                1. Hierarchy Types
                2. Hierarchy Properties
                3. Measure Group Filtering
                4. Alternative Captions
                  1. SAP BW Technical Names
              2. Elements
              3. Measures
                1. Measure Properties
              4. Refresh Metadata
              5. Languages
            3. Drop Zones Panel
            4. Content Panel
            5. Smart Insights
            6. Discover Pro Toolbox
              1. Item Picker
              2. Lassos in Discover Pro
                1. Select Lasso
                2. Zoom Lasso
            7. Query Metadata Pop-up
            8. Performance dialog
          3. Navigating and Querying Data
            1. Creating a New Report
            2. Building Queries
              1. Using Data Model Metadata
                1. Using the Hierarchies Tree
                  1. Using Attribute Hierarchies
                  2. Using Regular Hierarchies
                  3. Using Drill Path Hierarchies
                  4. Using Parent-Child Hierarchies
                  5. Using Geospatial Hierarchies
                  6. Using Date-Time Hierarchies
                  7. Using Image URL Hierarchies
                  8. Using URL Hierarchies
                  9. Using Hidden Hierarchy Properties
                2. Using the Elements Tree
                  1. Elements Tree Context Menu
                  2. List Builder
                  3. Members Search
                3. Using the Measures Tree
              2. Drop Zones
                1. Values Drop Zone
                  1. Colorize Values
                  2. Shapify Values
                2. Column and Row Drop Zone
                3. Categories Drop Zone
                4. Trellis Drop Zones
                5. Color Drop Zone
                6. Shape Drop Zone
                7. Size Drop Zone
                8. Labels Drop Zone
                9. Tooltip Drop Zone
                10. Indicator and Status Drop Zones
                11. Motion Drop Zone
                12. Details Drop Zone
                13. Map Location / Shape Drop Zone
                14. Filters Drop Zone
                  1. Calendar Slicers
                    1. Calendar Pickers
                    2. Calendar Slicer Settings
                  2. Tree Slicer
                  3. Slicer Limits
                  4. Cascading Slicers
                    1. Manually Building Cascading Slicers
                  5. Slicer Settings
                  6. Slicer Styles
                  7. Slicer Formatting
                  8. Background Filters
                  9. Making Slice Selections
                  10. Bookmarks
                  11. Pre-Query Slicers
                    1. Manage Pre-Query Bookmarks
                15. More Drop Zone Options
                  1. Copy or Move
              3. Building Visualizations
                1. Changing your Visualization Type
                2. Raw Results
                3. Grids
                  1. Matrix Grid
                  2. Tabular Grid
                4. Cartesian Charts
                  1. Column Chart
                  2. Stacked Column Chart
                  3. Stacked 100 Column Chart
                  4. Marimekko Chart
                  5. Bar Chart
                  6. Stacked Bar Chart
                  7. Stacked 100 Bar Chart
                  8. Tornado Chart
                  9. Multi-Measure Charts
                  10. Combo Charts
                  11. Line Chart
                  12. Point Charts
                  13. Lollipop Charts
                  14. Area Chart
                  15. Stream Chart
                5. IBCS-Like Charts
                  1. IBCS-Like Area Chart
                  2. IBCS-Like Column Chart
                  3. IBCS-Like Line Chart
                  4. IBCS-Like Lollipop Chart
                6. Segment Charts
                  1. Pie Chart
                  2. Doughnut Chart
                  3. Pyramid Chart
                  4. Funnel Chart
                  5. Multi-Measure Segment Charts
                7. Radar Charts
                8. Plotted Charts
                  1. Scatter Chart
                  2. Bubble Chart
                  3. Scatter Line Chart
                9. Advanced Charts
                  1. Tree Map Chart
                  2. Hierarchical Tree Map Chart
                  3. Circle Packing Chart
                  4. Hierarchical Circle Packing Chart
                  5. Sankey Chart
                  6. Word Cloud
                  7. Sunburst Chart
                10. KPI Charts
                  1. Gauges
                  2. Bullet Chart
                11. Maps
                  1. Bubble Maps
                  2. Shape Maps
                    1. Custom Maps
                  3. Geo Heat Map
                  4. Layered Maps
                  5. Map Quick Styles
                  6. Geo Boundaries
                12. Other Charts
                  1. Candlestick Chart
                  2. Box and Whisker Chart
                  3. Waterfall Chart
                  4. IBCS-Like Waterfall Chart
                13. Custom Visuals
                14. Conditional Formatting
                  1. Conditional Formatting Context Menu
                  2. Conditional Formatting via Drop Zones
                    1. Value Driven Colors
                    2. Conditional Color Examples
                    3. Text Indicator
                  3. Conditional Formatting Dialog
                  4. Conditional Formatting Logic
              4. Running Queries
                1. Query and Report Reset
            3. Changing and Manipulating Queries
              1. Query Interactions
                1. Drill-Up and Drill-Down
                2. Dice, Add, Swap, and Remove
                3. Expand and Collapse
                4. Element and Data Point Selection
                  1. Focus and Descendants
                5. Fill the Blanks
                6. Quick Sort
                  1. Set Element Order
                7. Quick Filters
                8. Pivot
                9. Quick Totals
                10. Explain
                  1. Explain explained
                  2. Explain the Difference
                11. Extended Query Interactions
                12. Interactive Selections
              2. Query Functions
                1. Show or Hide Empties
                2. Totals
                3. Sorting
                  1. Basic Sorting
                  2. Advanced Sorting
                  3. Sort Wizard
                4. Value Filtering
                5. Advanced Value Filtering
                6. Eliminations
                7. N-of-N
                8. Hide Query Info
              3. Advanced Query Functions
                1. Forecasting
                  1. Basic Forecasting
                  2. Advanced Forecasting
                    1. Custom Forecast Scripts
                2. Regression Functions
                3. Statistics
                4. Pareto
                5. Clustering
                6. Outliers
                7. Fill Blanks
            4. Calculations in Discover
              1. Quick Calculations
                1. Group Calculations
                2. Quick Formulas
                3. Quick Lists
                  1. Quick Variable Lists
                4. Quick Parameters
                  1. Quick Static Parameters
                5. Quick KPIs
                6. Managing Quick Calculations
                  1. Saving and Sharing Calculations
                  2. Internal Parameters
              2. Context Calculations
                1. Difference Context Functions
                2. Cumulative Context Functions
                3. Statistical Context Functions
                4. Advanced Analytic Context Functions
                5. Managing Context Calculations
                6. Customizing Context Calculations
              3. Custom Columns
                1. Aggregations
                2. Categorization
                3. Date Parts
                4. String Functions
                5. AI Driven Columns
                6. Managing Custom Columns
              4. Other Calculation Tools
                1. Time Calculation Wizard
                  1. To Date
                  2. Last n Periods
                  3. Periods
                    1. Full Period
                    2. Period On Period
                    3. Parallel Day
                    4. Parallel Period
                2. Variable Lists
            5. Query Options
              1. Query Settings
              2. Choose Language
              3. Model Colors and Formats
          4. Formatting and Design
            1. Copy Styles
            2. Reset Formatting
            3. Report Design
              1. Themes
              2. Report Title
              3. Background Color
              4. Show Notes
                1. AutoML Explanations
              5. Discover Runtime Settings
              6. Tooltip
              7. Auto-Colorize
              8. Member Color Lock
            4. Visualization Design
              1. Quick Styles
              2. IBCS-Like Charts
                1. IBCS-Like Area Chart
                2. IBCS-Like Column Chart
                3. IBCS-Like Line Chart
                4. IBCS-Like Lollipop Chart
                5. IBCS-Like Waterfall Chart
              3. Formatting Panel
                1. Grid Formatting in Discover Pro
                  1. Matrix Grid
                  2. Tabular Grid
                  3. Raw Grid
                  4. Data
                  5. Columns and Rows
                  6. Contextual Formatting
                  7. Clear Custom Formatting
                  8. In-Depth Grid Formatting Options
                    1. Alignment
                    2. Alternate Rows
                    3. Column Size
                    4. Expand Icons
                    5. Grid Borders
                    6. Grid Fonts
                    7. Grid Font Alignment
                    8. Grid Padding
                    9. Row Area Size
                    10. Total Formatting
                2. Cartesian Chart Formatting
                  1. Cartesian Charts
                  2. Chart Padding
                  3. Plot Area
                3. Segment Chart Formatting
                  1. Explode
                4. Radar Chart Formatting
                  1. Radar Line Chart
                5. Plotted Chart Formatting
                  1. Plotted Charts
                  2. Axis Position
                  3. Reference Line
                6. KPI Chart Formatting
                  1. Gauge Formatting
                    1. Gauge Labels
                      1. Gauge Value
                    2. Gauge Shape
                    3. Gauge Shadow
                    4. Auto Fit Labels
                    5. Gauge Scale
                  2. Bullet Chart Formatting
                    1. Bullet Chart Indicators
                    2. Bullet Chart Scale
                7. Advanced Chart Formatting
                  1. Circle Packing Chart
                  2. Sankey Chart
                  3. Sunburst Chart
                  4. Tree Map Chart
                  5. Waterfall Chart Formatting
                  6. Word Cloud Chart
                8. Map Formatting
                  1. Auto Center Map
                  2. Bubble Map Formatting
                  3. Shape Map Formatting
                  4. Geo Heat Map Formatting
                  5. Layered Map Formatting
                  6. Map Colors
                  7. Map Default Labels
                  8. Map Labels
                  9. Geospatial Defaults
                  10. Scale Control
                  11. Zoom Control
                9. Roundness Options
                10. Custom Visuals
              4. Common Design Capabilities
                1. Axes
                2. Color
                3. Data Labels
                  1. Data Label Optimization
                  2. Total Labels
                4. Legends
                  1. Combined Color Shape Legend
                  2. Legend Formatting
                  3. Series Editing
                5. Line Style
                6. Multi Chart Title
                7. Opacity
                8. Scale to Fit
                9. Shapes and Data Points
                10. Trellis Axes
                11. Visual Optimization
              5. Design Tools from the Ribbons
                1. Quick Styles
                  1. Grid Quick Styles
                  2. Cartesian Chart Quick Styles
                  3. Segment Chart Quick Styles
                  4. Plotted Chart Quick Styles
                  5. Map Quick Styles
                2. Axis Options
                3. Custom Reference Line
                4. Chart Border Width
                5. Mini Map
                6. Range Slider
                7. Custom Trellising
                8. Data Points
                9. Font Size
                10. Font Color
                11. Image Size
                12. Motion
                13. Readability
                14. Row Limit
                15. Show Data Grid
          5. Extended Functionality
            1. Discovery Actions
              1. Action Panel
                1. Jump To URL
                2. JavaScript Actions
                3. Tooltip Actions
                4. Action Library (PQL)
              2. Cube Actions
              3. Manage Actions
            2. Alerts Builder
              1. Advanced Alerts
              2. Smart Alerts
            3. Workflows and Conversations in Discover
              1. Start a Conversation
              2. Managing Workflows and Conversations
            4. SAP Parameters for BW and HANA
            5. Data Catalog Viewer
          6. Manage Discoveries
            1. Save and Share Discoveries
            2. Printing in Discover
            3. Discovery Subscriptions
            4. Open and Edit Discoveries
            5. User Defaults (Discover)
        6. Auto Discover
          1. Auto Discover Explained
      3. Formulate
        1. Common Formulate Workspace
          1. Common panels in Formulate
          2. Model Metadata in Formulate
          3. Script Editor
            1. Script Editor Ribbon
          4. AI Generated Script
          5. Chatbot Calculations
          6. Quick Discovery
          7. Quick Logic
          8. Functional Selection
          9. Internal Parameters
        2. Formulas (Members and Measures)
          1. Formula Ribbon
            1. Marketplace
            2. Multi-lingual Formulas
            3. Choose Language
          2. Formula Properties
            1. MDX Properties
            2. Formatting by Cell in MDX
            3. Dynamic Captions
              1. Walkthrough: Build Dynamic Captions
          3. Preview Panels
          4. Formula Script Editor
          5. Formula Examples
            1. Walkthrough: Percentage Markup Formula
            2. Walkthrough: Yearly Sales Variance
            3. Walkthrough: Custom Formula in Script Mode
        3. Lists (Sets)
          1. List Ribbon
            1. Move to Start or End
          2. List Properties
          3. List Script Editor
          4. List Actions
            1. Add
              1. Standard List
              2. Measure List
              3. Range List
              4. Full Month
              5. Full Quarter
              6. Full Week
              7. Full Year
              8. Month to Date
              9. Parallel Period
              10. Quarter To Date
              11. Week To Date
              12. Year To Date
            2. Derive
              1. Except / Remove
              2. Intersect
              3. Set Intersect
              4. Union
            3. Filter
              1. Bottom Count
              2. Bottom Percent
              3. Bottom Sum
              4. Contains
              5. Ends With
              6. Equals
              7. Filter
              8. First
              9. Last
              10. Starts With
              11. Top Count
              12. Top Percent
              13. Top Sum
            4. Sort
              1. Natural Order
              2. Order by Label
              3. Order by Selection
              4. Order by Value
            5. Fork
              1. If
              2. Switch
          5. List Examples
            1. Build a List
            2. List in Script Mode
        4. KPIs
          1. KPI Ribbons
          2. Building a KPI
            1. KPI Dynamic Bands
            2. KPI Script Editor
          3. Using KPIs
            1. Gauge Color Types
            2. Gauge Indicator Types
          4. Walkthroughs: KPIs
        5. Custom Columns
          1. Custom Column Ribbon
          2. Custom Column Properties
            1. Custom Column Settings
            2. Custom Column Measures
            3. Creating Measures
          3. Custom Column Panels
            1. Preview Panel
            2. Model Attributes Panel
          4. Custom Column Examples
            1. Walkthrough: Create New Attribute
            2. Walkthrough: Create New Measure
            3. Walkthrough: Custom Column in Script Mode
        6. Parameters
          1. Parameter Designer
          2. Dynamic List Parameters
          3. Parameter Types
            1. Discrete Parameters
            2. Continuous Parameters
            3. Free Form Parameters
        7. Scripting
          1. Shared Scripting
        8. Custom Visualizations
          1. Custom Visual Ribbon
      4. Present
        1. Present Interface Differences
          1. Changing Present Interfaces
        2. Getting started with Present
          1. Building a Presentation using Chatbot
          2. Building 'Pro' Presentation
          3. Building 'Lite' Presentation
        3. Smart Present
        4. Present Lite
          1. Accessing a 'Lite' presentation
          2. Workspace
            1. Ribbon
            2. Toolbox
            3. Canvas
              1. Metadata panel
            4. Slides and sections
            5. Slicers
          3. Building 'Lite' presentations
            1. Building a new presentation
            2. Adding content to a presentation
              1. Adding existing visuals
              2. Creating visuals using Smart Reporting
              3. Creating visuals using Discover Lite
              4. Creating Slicers
              5. Adding Static or Variable Text
              6. Adding Shapes or Images
              7. Adding a Table of Contents
              8. Adding Miniature visuals
            3. Managing Interactions
            4. Formatting and Design
              1. Selecting Themes
              2. Using Layout tools
                1. Aligning and distributing items
                2. Grouping and ungrouping items
              3. Auto Layout
        5. Present Pro
          1. Accessing a 'Pro' presentation
          2. Workspace
            1. Ribbons
              1. Master Page Ribbon
            2. Toolbox
            3. Canvas
              1. Context Menus
              2. Metadata
              3. Canvas Size
            4. Slides and sections
            5. Slicers
            6. Content and Used Content
            7. Formatting Panel
            8. Targets
          3. Building a 'Pro' presentation
            1. Building a new 'Pro' presentation
              1. Tooltip Presentations
              2. Mobile Presentations
            2. Adding Content items
              1. Adding Visuals and Analytic data
                1. Adding existing visuals
                  1. Unlinking Content
                2. Creating visuals using Smart Reporting
                3. Creating visuals using Discover Lite
              2. Managing Slicers
                1. Adding an "advanced" slicer
                2. Adding a "quick" slicer
                3. Slicer Settings
                4. Slicer Styles
                5. Hidden Slicers
                6. Edit and Delete Slicers
                7. Duplicating Slicers
                8. Detaching Slicers
                9. Populating slicers with parameters
              3. Presentation Assets
                1. Static Shapes and Images
                  1. AI Image Generator
                2. Variable text fields
                  1. Adding a Table of Contents
                  2. Adding a "Model Processed Date"
                  3. Adding Slide Insights
                3. Dynamic web panels
                4. Integrating dynamic illustrations
                5. Dynamic Text
                  1. Highlight dynamic text
                  2. Empty Strings in dynamic text
                  3. Auto Translate dynamic text
                6. Dynamic Placeholders
                7. Dynamic Tooltips
            3. Interactivity
              1. Configuring Interactions
                1. Interaction Manager
                  1. Cross-Filtering Slicers Example
                  2. Cross-Highlighting Slicers Example
                2. Interaction Picker
                3. Auto Interact
                4. Showing Interactions
                5. Removing interactions
                6. Model Mapping
                7. Creating Targets
              2. Creating Actions
                1. Creating Slicer Actions
                2. Creating Visual Actions
                3. Creating Tooltip Actions
              3. Creating Dynamic Jump Actions
                1. Jump to Slide
                2. Jump to Content Item
                3. Jump to Tab
                4. Jump to URL
                5. Execute JavaScript
                6. Publication Print
                7. Run slicers
            4. Formatting and Design
              1. Themes
              2. Master Pages
                1. Navigation Options
              3. Formatting and Format selection
                1. Grid Sizing
              4. Slicer Formatting
                1. Panel Settings
            5. Layouts
              1. Using layout containers
                1. Mini-Tab Layout
                  1. Conditional Display for Mini-Tabs
                2. Scroll Panel Layout
                3. Matrix Table Layout
              2. Using layout tools
                1. Adding Guides and Rulers
                2. Stacking order
                3. Aligning and distributing items
                4. Grouping and ungrouping items
              3. Visual Options
                1. Optimizing for Device Types
                2. Scaling assets
                  1. Auto Fit Labels
                  2. Auto Fit Graphic Text
                3. Panels
                4. Legends
                5. Range Sliders
                6. Miniature Visuals
              4. Auto Layout
            6. Runtime Settings
              1. Setting the scope of runtime interactions
              2. Configuring runtime capabilities
              3. Configuring model / hierarchy access
              4. Configuring the runtime timer
            7. Refresh snapshots in Present Pro
        6. Managing presentations
          1. Saving and sharing presentations
          2. Opening and editing presentations
          3. Running presentations
        7. Running Presentations
          1. Context Menus
            1. Zoom effects
            2. Triggering actions at runtime
            3. Quick Sort wizard at Present runtime
          2. Present runtime menu
            1. Bookmarking slicer selections
            2. Pre-query slicers
            3. Run slicers at runtime
          3. Interactivity at runtime
            1. Cross-Highlighting at Runtime
            2. Cross-Filtering at Runtime
            3. Sync Interactions at Runtime
            4. Multi-Select Highlighting
          4. Analyze Further
            1. OData Link
          5. Runtime Chatbot
            1. Using the Chatbot at Runtime
          6. Automated Insights
          7. Print from Present at Runtime
          8. Subscriptions in Present
          9. Runtime Alerts
          10. Workflows and Conversations
          11. Panel tools at runtime
          12. Explanations at runtime
          13. Slide navigation at runtime
      5. Publish
        1. Smart Publish
        2. Publish Lite
          1. Access Publish Lite
          2. Publish Lite Workspaces
            1. Publish Lite Ribbon
            2. Publish Lite Toolbox
            3. Publish Lite Pages
            4. Publish Lite Canvas
          3. Build Lite Publications
            1. Add Content
            2. Add Slicers
            3. Add Static Text
            4. Dynamic Text
              1. Dynamic Text Fields
              2. Dynamic Placeholders
            5. Table of Contents
            6. Add Static Graphics
            7. Context Menus
            8. Interaction Manager
            9. Themes
            10. Cover Pages
            11. Align and Distribute
            12. Grouping
          4. Manage Lite Publications
            1. Save Lite Publications
            2. Print and Export
            3. Subscriptions
            4. Link Back to Live Content
        3. Publish Pro
          1. Publication Overview
            1. Building Publications
              1. Publication Workspace
              2. Publish Pro Ribbons
              3. Context Menus
              4. Text and Shapes
              5. Build a Publication
              6. Build a Publication using the Chatbot
          2. Publication Design
            1. AI Image Generator
            2. Refresh Snapshots
            3. Page Sizes and Orientation
            4. Content Layout Tools
            5. Publication Templates
            6. Auto Layout Publish
            7. Content Captioning
            8. Publication Legends
            9. Text Fields
              1. Generating Page Insights
            10. Flow Visual
            11. Grid Sizing
            12. Unlink Content
            13. Formatting Panel
              1. Panel Settings
            14. Show Warnings
            15. Layout Containers
              1. Matrix Table Layout
              2. Conditional Display
          3. Publication Analytics
            1. Publication Slicers and Interactions
              1. New Quick Slicer
              2. Advanced Slicer Wizard
              3. Page Repeater
              4. Interaction Manager
              5. Range Slicers in Publish
              6. Cross Model Mapping
            2. Dynamic Text
              1. Dynamic Text Editor
              2. Empty Strings
              3. Dynamic Place Holder
          4. Publishing and Distribution
            1. Printing in Publish
            2. Subscribe to Publication
            3. Scheduled Publishing
            4. PDF Bookmarks
            5. Link-Back
            6. Distribution
              1. Bulletin Board Distribution
              2. Email Distribution
              3. Static Distribution List
              4. Dynamic Distribution
                1. Distribution via File Mapping
                  1. Walkthrough: File Mapping
                2. Distribution via Data Mapping
                  1. Walkthrough: Data Mapping
              5. Triggers
            7. Access Scheduled Publications
      6. Illustrate
        1. Illustrate Ribbons
          1. Layout tools in Illustrate
        2. Dynamic Images
          1. Dynamic Graphic Properties
          2. Import Images
          3. Build Dynamic Images
        3. Dynamic Text
          1. Dynamic Text Properties
          2. Dynamic Text
          3. Empty Strings
          4. Graphic Text
        4. Dynamic Tooltips
        5. Dynamic Functions
        6. Use Dynamic Images and Texts
      7. Tabulate
        1. Tabulate Pro
          1. Accessing Tabulate
            1. Open an existing tabulation
            2. How to Enable/Disable Tabulate
          2. Tabulate Workspace
            1. Tabulate Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Ribbons
            3. Tabulate Pro Toolbox
            4. Tabulate Status Bar
            5. Tabulate Sheets
            6. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Find and Replace
              8. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Gridlines
              2. Headers
              3. Themes
              4. Cell Formatting
              5. Number Formatting
              6. Tables
              7. Filtering and Sorting
              8. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Drag discoveries into Tabulate Pro
                1. Working with discoveries in tabulations
              2. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              3. Slicers
                1. Attaching Slicers
                2. Pre-Query Slicers (Tabulate)
              4. Parameters
                1. Attaching Parameters
                2. Editing Parameters
                3. Internal Parameters
              5. Managing Data Sources
                1. Cross Model Mapping
              6. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding Visual Areas in Present, Publish, and Illustrate
            1. Editing Visuals and Visual Areas in Tabulate
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
          7. Solve Overview
            1. Optimization Explained
            2. Using Solve
            3. Solve Panel
              1. Solve Advanced Settings
            4. Complete Solve Example
        2. Tabulate Lite
          1. Accessing Tabulate Lite
            1. Open an existing tabulation
            2. How to Enable/Disable Tabulate
          2. Tabulate Lite Workspace
            1. Tabulate Lite Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Lite Ribbons
            3. Tabulate Lite Toolbox
            4. Slicers
            5. Tabulate Status Bar
            6. Tabulate Sheets
            7. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Find and Replace
              7. Named Ranges
              8. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Themes
              2. Cell Formatting
              3. Number Formatting
              4. Tables
              5. Filtering and Sorting
              6. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Drag discoveries into Tabulate Lite
                1. Working with discoveries in tabulations
              2. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              3. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding Visual Areas in Present, Publish, and Illustrate
            1. Editing Visuals and Visual Areas in Tabulate
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
  3. Analyst User
    1. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
            1. Context Menu Configuration
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
          3. Chat Search in your Hub
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Quick Open
        3. App Tab Manager
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. App Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
          1. Dynamic Clipboard Tools
        3. Text Formatting
        4. Saving Content
          1. Assigning Content Access
        5. Print and Export
          1. Printing from Embedded Content
        6. Subscriptions
          1. Configure Subscriptions
        7. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
        8. Data Source Authentication
    2. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    3. Lite Apps
      1. Discover Lite
        1. Access Discover Lite
        2. Discover Lite Workspace
          1. Drop Zones
          2. Discover Lite Ribbon
            1. Axis Options
            2. Data Labels
            3. Data Points
            4. Grid Lines
            5. Bookmarks
          3. Model Metadata and Trees
          4. App Tabs Menus
        3. Build Visuals in Discover Lite
          1. Drop Zones
          2. Toolbox
            1. Quick Styles
          3. Dynamic Interactions
            1. Quick Sort Wizard
          4. Quick Calculations
          5. Context Calculations
          6. Running Queries
        4. Manage Visuals in Discover Lite
        5. Conversations
      2. Present Lite
        1. Accessing a 'Lite' presentation
        2. Workspace
          1. Ribbon
          2. Toolbox
          3. Canvas
            1. Metadata panel
          4. Slides and sections
          5. Slicers
        3. Building 'Lite' presentations
          1. Building a new presentation
          2. Adding content to a presentation
            1. Adding existing visuals
            2. Creating visuals using Smart Reporting
            3. Creating visuals using Discover Lite
            4. Creating Slicers
            5. Adding Static or Variable Text
            6. Adding Shapes or Images
            7. Adding a Table of Contents
            8. Adding Miniature visuals
          3. Managing Interactions
          4. Formatting and Design
            1. Selecting Themes
            2. Using Layout tools
              1. Aligning and distributing items
              2. Grouping and ungrouping items
            3. Auto Layout
      3. Publish Lite
        1. Access Publish Lite
        2. Publish Lite Workspaces
          1. Publish Lite Ribbon
          2. Publish Lite Toolbox
          3. Publish Lite Pages
          4. Publish Lite Canvas
        3. Build Lite Publications
          1. Add Content
          2. Add Slicers
          3. Add Static Text
          4. Dynamic Text
            1. Dynamic Text Fields
            2. Dynamic Placeholders
          5. Table of Contents
          6. Add Static Graphics
          7. Context Menus
          8. Interaction Manager
          9. Themes
          10. Cover Pages
          11. Align and Distribute
          12. Grouping
        4. Manage Lite Publications
          1. Save Lite Publications
          2. Print and Export
          3. Subscriptions
          4. Link Back to Live Content
      4. Tabulate Lite
        1. Accessing Tabulate Lite
          1. Open an existing tabulation
          2. How to Enable/Disable Tabulate
        2. Tabulate Lite Workspace
          1. Tabulate Lite Canvas
            1. Zoom in or out of a sheet
          2. Tabulate Lite Ribbons
          3. Tabulate Lite Toolbox
          4. Slicers
          5. Tabulate Status Bar
          6. Tabulate Sheets
          7. Hiding and Showing Sheets
        3. Working with Spreadsheets
          1. Data Entry and Cells
            1. Rows and Columns
            2. Resizing Rows and Columns
            3. Hide and Show Rows and Columns
            4. Freeze Panes
            5. Clipboard
            6. Find and Replace
            7. Named Ranges
            8. Working with Formulas
              1. More Formula Details
              2. Formula Bar
              3. Formula Wizard
          2. Formatting
            1. Themes
            2. Cell Formatting
            3. Number Formatting
            4. Tables
            5. Filtering and Sorting
            6. Conditional Formats in Tabulate
              1. Applying Conditional Formats
          3. Using Live Data
            1. Drag discoveries into Tabulate Lite
              1. Working with discoveries in tabulations
            2. Importing Data and Content
              1. Smart Report
              2. Discover Lite
              3. Importing Existing Spreadsheets
            3. Blending Queries
        4. Creating Tabulate Visuals
          1. Drop Zones
          2. Formatting Panels
          3. Panel Layout
        5. Embedding Visual Areas in Present, Publish, and Illustrate
          1. Editing Visuals and Visual Areas in Tabulate
        6. Managing Tabulations
          1. Saving Tabulations
          2. Printing and Exporting
          3. Mobile Access
  4. Viewer User
    1. Viewer Workflow Overview
    2. Viewer Home Page
      1. Viewer Home Menu
        1. System Info
        2. User Defaults
      2. Viewer User Hub
      3. Content Management for Viewers
        1. Content Types
        2. Content Manager
          1. Favorites
          2. Recents
          3. Content Explorer
          4. Most Used
          5. User Recommended
          6. Auto Recommended
          7. Content Search
        3. Schedule and Subscription Toolbox
          1. Publications Board
          2. Alerts Board
          3. Subscriptions Board
          4. Workflow and Conversations Board
          5. Schedule Manager
            1. Alerts Manager
            2. Subscriptions Manager
    3. Interactive Content
      1. Data Discoveries
        1. Discovery Slicers
        2. Discovery Lassos
      2. Presentations
        1. Presentation Slicers
        2. Cross-Visual Interactions
        3. Panel Tools
      3. Viewer Interactions
        1. Conversations
        2. Alerts
        3. Analyze Further
          1. Members Search
    4. Manage Viewer Content
      1. Print and Export
      2. Subscribe to Content
        1. Link Back to Live Content
    5. Mobile and Tablet App
      1. Viewer Mobile Navigation
      2. Open Viewer Content
  5. Basic User
    1. Embed Experience
      1. Quick Sort wizard
    2. Embed Hub
    3. Link Back to Live Content
    4. OData Link
  6. Mobile Client
    1. Mobile Phones
      1. Mobile Content Navigation
      2. Open Content
      3. Mobile Interactions
    2. Tablets
      1. App Menu
      2. Thumb Button and Context Menus
      3. Element Tree Navigation
      4. Accessing the Ribbons
      5. Accessing Sub-menus
      6. Quick Calculations
      7. Tablet Presentations
  7. Natural Language Interfaces
    1. Chatbot and Questions
      1. Access the Chatbot at Design Time
      2. Access the Chatbot at Runtime
      3. Chatbot Functions
        1. Speak to the Chatbot
      4. Writing Natural Language Queries
        1. NLQ: Asking a Basic Question
        2. NLQ: Advanced Intelligence
        3. NLQ: Visualizations
    2. Multiple LLM Engines
      1. Portable Language Model Guidance

Admin Help

  1. Admin Hub
    1. Diagnostic Dashboard
      1. Restarting Services
      2. Disabling Services
      3. In-Memory DB Status
    2. LLM Token Tracker
    3. Cluster Resources
    4. System Usage KPI
  2. Licensing
    1. License Change Wizard
    2. Deactivation of Pyramid
  3. Access
    1. Users
      1. Adding or Editing Users Manually
        1. Adding Users through Search
      2. Importing Users
      3. Admin Rights
    2. Role Management
      1. Importing Roles
    3. Tenant Management
    4. Profiles
      1. Pro User Profile
      2. Analyst User Profile
      3. Viewer User Profile Settings
    5. User Defaults (Admin)
    6. Provisioning
  4. Security
    1. Authentication
      1. Authentication Providers
        1. Internal Database
          1. Multi-Factor Authentication
        2. LDAP Authentication
          1. Active Directory
          2. Azure Active Directory
            1. Azure LDAPS
          3. Open LDAP
        3. SAML Authentication
          1. Azure SAML
          2. ADFS SAML
          3. AWS SAML
          4. Google SAML
          5. Okta SAML
          6. Ping SAML
        4. OpenID Authentication
          1. Azure OpenID
          2. Okta OpenID
          3. Ping OpenID
          4. Google OpenID
        5. Convert Users
        6. User Provisioning from IDPs
          1. Azure User Provisioning
          2. Google User Provisioning
          3. Okta User Provisioning
          4. Ping User Provisioning
    2. Certificate Manager
      1. IMDB Encryption
    3. Server-Side Security
    4. Client Security
  5. Data
    1. Data Sources
      1. Data Source Setups
        1. Data Access with Windows Authentication
        2. Single Sign-on via OAuth
        3. Amazon OAuth Setup
        4. Box Setup
        5. Facebook Setup
        6. FTP Setup
        7. Google Security Setup
        8. Microsoft Analysis Services Setup
        9. Microsoft Fabric Setup
        10. ODBC Setup
        11. SAP BW Setup
        12. SAP HANA Setup
        13. SalesForce Setup
        14. X (Twitter) Setup
      2. Xtender Data Source Setup
    2. Source Manager
      1. Data Source Servers (Admin)
      2. Database Management (Admin)
        1. Copy or Move a Data Model
        2. Xtender Database Setup
      3. Data Model Management (Admin)
        1. Attribute Security
        2. Hierarchy Overlay
        3. Measure Security
        4. Measure Overlay
        5. Level Overlay
        6. Member Security
          1. Dynamic Member Security
          2. Security PQL Script Editor
    3. Pulse Nodes
    4. Kerberos Keytabs
    5. Custom Connectors
    6. Caching
    7. Query Limits
    8. Data Source Limits
    9. Global Settings
  6. Content
    1. Content Settings
    2. Migration Destinations
    3. Webhooks
    4. Custom Workflows
  7. Services
    1. General Settings
    2. Server Instances
      1. Service Memory Limits
    3. Runtime Services
    4. Task Services
    5. Solve Services
    6. Web Services
      1. Web Settings
    7. Primary File Storage
    8. File System
    9. Message Settings
  8. Schedules
    1. Task Manager
    2. Publication Schedules
    3. Alerts Schedules
    4. Subscriptions Schedules
    5. Models Schedules
    6. Auto Provisioning Jobs
    7. System Schedule
  9. Logs
    1. Entries
    2. Transaction Log
    3. Solve Logs
    4. System Log
    5. Deleted Items Log
    6. Log Settings
      1. Log Shipping
      2. Audit Trail Framework
  10. Mobile Devices
    1. Devices
    2. Mobile Devices Settings
  11. Design
    1. App Experience
    2. Themes
      1. Theme Editor
      2. Master Pages
    3. Custom Fonts
    4. Email Templates
      1. Add or Edit Email Template
    5. Hub Templates
      1. Build Hub Templates
      2. Hub Snippet Generator
  12. Geospatial
    1. Custom Maps
    2. Geospatial Settings
  13. AI and DSML
    1. AI Settings
    2. LLM Manager
      1. Integrating LLMs with Pyramid
    3. DSML Settings
    4. DSML Environments

Guides

  1. General Guides
    1. Pyramid Licensing
      1. Solve Access
    2. Application Languages
    3. Versions and Releases
      1. Version History
      2. Older Versions of Help
    4. Other Pyramid Help Resources
  2. Installation Guides
    1. Main Application
      1. System Requirements
      2. Quick Guide for Windows
      3. Quick Guide for Linux
      4. Upgrade Installations
      5. Unattended Installations
      6. Installation Steps
        1. Installation Rights
        2. Installation Directories
        3. Encryption and FIPS
          1. Encrypting Connections
        4. Server Deployment
          1. Adding and Removing Services
        5. Database Repository Installation
        6. Web Server Installation
          1. NGINX Web Server
          2. IIS Web Server
        7. Initialization
        8. Post-Installation Adjustments
        9. Offline Installation
          1. Offline Installation of R and Python
        10. Product Activation
          1. Trial Registrations
          2. New Deployment Activation
          3. Offline Registrations
          4. Changing Licensed Servers
      7. Repository Backups
        1. Recovery
    2. Kubernetes
      1. Recommendations for Kubernetes
      2. Kubernetes Configurator
      3. HELM Charts
        1. Unattended Kubernetes Configuration
        2. HELM Configuration
      4. Kubernetes Initialization
        1. Kubernetes Unattended Initialization
      5. Kubernetes Recipes
        1. Pyramid on AWS Kubernetes
        2. Pyramid on Azure Kubernetes
        3. Pyramid on GCP Kubernetes
    3. Pulse
      1. Pulse Installation Steps
    4. Cloud Server Quick Start
      1. Pyramid Analytics for AWS Marketplace
    5. Client Desktop
    6. System Maintenance Tools
    7. Uninstallation
  3. Configuration Guides
    1. Kerberos Delegation for Pyramid
    2. Load Balancer
    3. "Xtender" Data Exchanger
    4. In-Memory Database Guide
  4. Deployment and Security Guides
    1. Scaling Pyramid
    2. Pyramid Usage
    3. User Deployment in Pyramid
    4. Application Security Overview
    5. Security Hardening Guide
    6. FIPS Compliance
    7. Mobile App Deployment
    8. Creating Accessible Content
  5. Miscellaneous Guides
    1. BI Office Content Conversion
    2. Generative AI Integration
    3. Dynamic Function Wizard
  6. SAP Guides
    1. SAP SSO 'SNC' Setup Guide
    2. Support for SAP BW Features
    3. Troubleshooting Guide for SAP BW

Tech Reference

  1. Query & Function Overview
    1. PQL & MDX Language Reference
      1. MDX Language
        1. Semantic Library (MDX)
          1. Date-Time Functions
            1. ClosingPeriod
            2. LastPeriods
            3. MTD
            4. OpeningPeriod
            5. ParallelPeriod
            6. PeriodsToDate
            7. QTD
            8. WTD
            9. YTD
          2. Hierarchical Functions
            1. Ascendants
            2. Children
            3. Cousin
            4. Descendants
            5. Dimension
            6. Dimensions
            7. DrilldownLevel
            8. DrilldownLevelBottom
            9. DrilldownLevelTop
            10. DrilldownMember
            11. DrilldownMemberBottom
            12. DrilldownMemberTop
            13. DrillupLevel
            14. DrillupMember
            15. FirstChild
            16. FirstSibling
            17. Hierarchy
            18. LastChild
            19. LastSibling
            20. Level
            21. Levels
            22. Ordinal
            23. Parent
            24. RollupChildren
            25. Root
            26. Siblings
          3. KPI Functions
            1. KPICurrentTimeMember
            2. KPIGoal
            3. KPIStatus
            4. KPITrend
            5. KPIValue
            6. KPIWeight
          4. List Functions
            1. AddCalculatedMembers
            2. AllMembers
            3. Ancestors
            4. Axis
            5. BottomCount
            6. BottomPercent
            7. BottomSum
            8. Crossjoin
            9. Distinct
            10. Except
            11. Exists
            12. Extract
            13. Filter
            14. Generate
            15. Head
            16. Hierarchize
            17. Intersect
            18. Leaves
            19. MeasureGroupMeasures
            20. Members
            21. NameToSet
            22. NonEmpty
            23. NonEmptyCrossjoin
            24. Order
            25. StripCalculatedMembers
            26. Subset
            27. Tail
            28. ToggleDrillState
            29. TopCount
            30. TopPercent
            31. TopSum
            32. Union
            33. Unorder
          5. Logical Functions
            1. Error
            2. IIf
            3. IsAncestor
            4. IsEmpty
            5. IsGeneration
            6. IsLeaf
            7. IsSibling
          6. Member Functions
            1. Ancestor
            2. Current
            3. CurrentMember
            4. DataMember
            5. DefaultMember
            6. Item
            7. Lag
            8. Lead
            9. LinkMember
            10. NextMember
            11. PrevMember
            12. UnknownMember
          7. Other Functions
            1. CalculationCurrentPass
            2. CalculationPassValue
            3. CoalesceEmpty
            4. CurrentOrdinal
            5. LookupCube
            6. Properties
            7. SetToArray
            8. UserName
            9. ValidMeasure
            10. Value
          8. Statistical Functions
            1. Aggregate
            2. Avg
            3. Correlation
            4. Count
            5. Covariance
            6. CovarianceN
            7. DistinctCount
            8. LinRegIntercept
            9. LinRegPoint
            10. LinRegR2
            11. LinRegSlope
            12. LinRegVariance
            13. Max
            14. Median
            15. Min
            16. Predict
            17. Rank
            18. Stdev
            19. StdevP
            20. Sum
            21. Variance
            22. VarianceP
            23. VisualTotals
          9. String Functions
            1. MemberToStr
            2. Name
            3. SetToStr
            4. StrToMember
            5. StrToSet
            6. StrToTuple
            7. StrToValue
            8. TupleToStr
            9. UniqueName
        2. VBA Library (MDX)
          1. Conversion Functions
            1. CBool
            2. CByte
            3. CCur
            4. CDate
            5. CDbl
            6. CDec
            7. CInt
            8. CLng
            9. CSng
            10. CStr
            11. CVar
            12. TypeName
          2. Date-Time Functions
            1. Date
            2. DateAdd
            3. DateDiff
            4. DatePart
            5. DateSerial
            6. DateValue
            7. Day
            8. Hour
            9. Minute
            10. Month
            11. Now
            12. Second
            13. Timer
            14. TimeSerial
            15. TimeValue
            16. Weekday
            17. Year
          3. Financial Functions
            1. DDB
            2. FV
            3. IPmt
            4. IRR
            5. MIRR
            6. NPer
            7. NPV
            8. Pmt
            9. PPmt
            10. PV
            11. Rate
            12. SLN
            13. SYD
          4. Logical Functions
            1. Choose
            2. Iif
            3. IsArray
            4. IsDate
            5. IsEmpty
            6. IsError
            7. IsMissing
            8. IsNull
            9. IsNumeric
            10. Switch
          5. Math Functions
            1. Abs
            2. Atn
            3. Cos
            4. Exp
            5. Fix
            6. Int
            7. Log
            8. QBColor
            9. RGB
            10. Rnd
            11. Round
            12. Sgn
            13. Sin
            14. Sqr
            15. Tan
          6. String Functions
            1. Asc
            2. Chr
            3. Format
            4. Hex
            5. InStr
            6. LCase
            7. Left
            8. Len
            9. LTrim
            10. Mid
            11. Oct
            12. Partition
            13. Right
            14. RTrim
            15. Space
            16. Str
            17. StrComp
            18. StrConv
            19. String
            20. Trim
            21. UCase
            22. Val
        3. Spreadsheet Library (PQL)
          1. Pyramid Functions
            1. DATA
            2. MEMBER
            3. PARAMETER
            4. SLICER
            5. SLICERCAPTION
          2. Database Functions
            1. DAVERAGE
            2. DCOUNT
            3. DCOUNTA
            4. DGET
            5. DMAX
            6. DMIN
            7. DPRODUCT
            8. DSTDEV
            9. DSTDEVP
            10. DSUM
            11. DVAR
            12. DVARP
          3. Date & Time Functions
            1. DATE
            2. DATEDIF
            3. DATEVALUE
            4. DAY
            5. DAYS
            6. DAYS360
            7. EDATE
            8. EOMONTH
            9. HOUR
            10. ISOWEEKNUM
            11. MINUTE
            12. MONTH
            13. NETWORKDAYS
            14. NETWORKDAYS.INTL
            15. NOW
            16. SECOND
            17. TIME
            18. TIMEVALUE
            19. TODAY
            20. WEEKDAY
            21. WEEKNUM
            22. WORKDAY
            23. WORKDAY.INTL
            24. YEAR
            25. YEARFRAC
          4. Engineering Functions
            1. BESSELI
            2. BESSELJ
            3. BESSELK
            4. BESSELY
            5. BIN2DEC
            6. BIN2HEX
            7. BIN2OCT
            8. BITAND
            9. BITLSHIFT
            10. BITOR
            11. BITRSHIFT
            12. BITXOR
            13. COMPLEX
            14. CONVERT
            15. DEC2BIN
            16. DEC2HEX
            17. DEC2OCT
            18. DELTA
            19. ERF
            20. ERF.PRECISE
            21. ERFC
            22. ERFC.PRECISE
            23. GESTEP
            24. HEX2BIN
            25. HEX2DEC
            26. HEX2OCT
            27. IMABS
            28. IMAGINARY
            29. IMARGUMENT
            30. IMCONJUGATE
            31. IMCOS
            32. IMCOSH
            33. IMCOT
            34. IMCSC
            35. IMCSCH
            36. IMDIV
            37. IMEXP
            38. IMLN
            39. IMLOG10
            40. IMLOG2
            41. IMPOWER
            42. IMPRODUCT
            43. IMREAL
            44. IMSEC
            45. IMSECH
            46. IMSIN
            47. IMSINH
            48. IMSQRT
            49. IMSUB
            50. IMSUM
            51. IMTAN
            52. OCT2BIN
            53. OCT2DEC
            54. OCT2HEX
          5. Financial Functions
            1. ACCRINT
            2. ACCRINTM
            3. AMORDEGRC
            4. AMORLINC
            5. COUPDAYBS
            6. COUPDAYS
            7. COUPDAYSNC
            8. COUPNCD
            9. COUPNUM
            10. COUPPCD
            11. CUMIPMT
            12. CUMPRINC
            13. DB
            14. DDB
            15. DISC
            16. DOLLARDE
            17. DOLLARFR
            18. DURATION
            19. EFFECT
            20. FV
            21. FVSCHEDULE
            22. INTRATE
            23. IPMT
            24. IRR
            25. ISPMT
            26. MDURATION
            27. MIRR
            28. NOMINAL
            29. NPER
            30. NPV
            31. ODDFPRICE
            32. ODDFYIELD
            33. ODDLPRICE
            34. ODDLYIELD
            35. EURO
            36. EUROCONVERT
            37. PDURATION
            38. PMT
            39. PPMT
            40. PRICE
            41. PRICEDISC
            42. PRICEMAT
            43. PV
            44. RATE
            45. RECEIVED
            46. RRI
            47. SLN
            48. SYD
            49. TBILLEQ
            50. TBILLPRICE
            51. TBILLYIELD
            52. VDB
            53. XIRR
            54. XNPV
            55. YIELD
            56. YIELDDISC
            57. YIELDMAT
          6. Information Functions
            1. ERROR.TYPE
            2. ISBLANK
            3. ISERR
            4. ISERROR
            5. ISEVEN
            6. ISFORMULA
            7. ISLOGICAL
            8. ISNA
            9. ISNONTEXT
            10. ISNUMBER
            11. ISODD
            12. ISOMITTED
            13. ISREF
            14. ISTEXT
            15. N
            16. NA
            17. SHEET
            18. SHEETS
            19. TYPE
          7. Logical Functions
            1. AND
            2. BYCOL
            3. BYROW
            4. IF
            5. IFERROR
            6. IFNA
            7. IFS
            8. LAMBDA
            9. LET
            10. MAKEARRAY
            11. MAP
            12. NOT
            13. OR
            14. REDUCE
            15. SCAN
            16. SWITCH
            17. XOR
          8. Lookup Functions
            1. ADDRESS
            2. AREAS
            3. CHOOSE
            4. CHOOSECOLS
            5. CHOOSEROWS
            6. COLUMN
            7. COLUMNS
            8. DROP
            9. EXPEND
            10. FILTER
            11. FORMULATEXT
            12. HLOOKUP
            13. HSTACK
            14. HYPERLINK
            15. INDEX
            16. INDIRECT
            17. LOOKUP
            18. MATCH
            19. OFFSET
            20. ROW
            21. ROWS
            22. SORT
            23. SORTBY
            24. TOCOL
            25. TOROW
            26. TRANSPOSE
            27. UNIQUE
            28. VLOOKUP
            29. VSTACK
            30. WRAPCOLS
            31. WRAPROWS
            32. XLOOKUP
            33. XMATCH
          9. Math & Trig Functions
            1. ABS
            2. ACOS
            3. ACOSH
            4. ACOT
            5. ACOTH
            6. AGGREGATE
            7. ARABIC
            8. ASIN
            9. ASINH
            10. ATAN
            11. ATAN2
            12. ATANH
            13. BASE
            14. CEILING
            15. CEILING.MATH
            16. CEILING.PRECISE
            17. COMBIN
            18. COMBINA
            19. COS
            20. COSH
            21. COT
            22. COTH
            23. CSC
            24. CSCH
            25. DECIMAL
            26. DEGREES
            27. EVEN
            28. EXP
            29. FACT
            30. FACTDOUBLE
            31. FLOOR.MATH
            32. FLOOR.PRECISE
            33. GCD
            34. INT
            35. ISO.CEILING
            36. LCM
            37. LN
            38. LOG
            39. LOG10
            40. MDETERM
            41. MINVERSE
            42. MMULT
            43. MOD
            44. MROUND
            45. MULTINOMIAL
            46. ODD
            47. PI
            48. POWER
            49. PRODUCT
            50. QUOTIENT
            51. RADIANS
            52. RAND
            53. RANDARRAY
            54. RANDBETWEEN
            55. ROMAN
            56. ROUND
            57. ROUNDDOWN
            58. ROUNDUP
            59. SEC
            60. SECH
            61. SEQUENCE
            62. SERIESSUM
            63. SIGN
            64. SIN
            65. SINH
            66. SQRT
            67. SQRTPI
            68. SUBTOTAL
            69. SUM
            70. SUMIF
            71. SUMIFS
            72. SUMPRODUCT
            73. SUMSQ
            74. SUMX2MY2
            75. SUMX2PY2
            76. SUMXMY2
            77. TAN
            78. TANH
            79. TRUNC
          10. Statistical Functions
            1. AVEDEV
            2. AVERAGE
            3. AVERAGEA
            4. AVERAGEIF
            5. AVERAGEIFS
            6. BETA.DIST
            7. BETA.INV
            8. BINOM.DIST
            9. BINOM.DIST.RANGE
            10. BINOM.INV
            11. CHISQ.DIST
            12. CHISQ.DIST.RT
            13. CHISQ.INV
            14. CHISQ.INV.RT
            15. CHISQ.TEST
            16. CONFIDENCE.NORM
            17. CONFIDENCE.T
            18. CORREL
            19. COUNT
            20. COUNTA
            21. COUNTBLANK
            22. COUNTIF
            23. COUNTIFS
            24. COVARIANCE.P
            25. COVARIANCE.S
            26. DEVSQ
            27. EXPON.DIST
            28. F.DIST
            29. F.DIST.RT
            30. F.INV
            31. F.INV.RT
            32. F.TEST
            33. FINV
            34. FISHER
            35. FISHERINV
            36. FORECAST
            37. FREQUENCY
            38. GAMMA
            39. GAMMA.DIST
            40. GAMMA.INV
            41. GAMMALN
            42. GAMMALN.PRECISE
            43. GAUSS
            44. GEOMEAN
            45. GROWTH
            46. HARMEAN
            47. HYPGEOM.DIST
            48. INTERCEPT
            49. KURT
            50. LARGE
            51. LINEST
            52. LOGEST
            53. LOGNORM.DIST
            54. LOGNORM.INV
            55. MAX
            56. MAXA
            57. MAXIFS
            58. MEDIAN
            59. MIN
            60. MINA
            61. MINIFS
            62. MODE.MULT
            63. MODE.SNGL
            64. NEGBINOM.DIST
            65. NORM.DIST
            66. NORM.INV
            67. NORM.S.DIST
            68. NORM.S.INV
            69. PEARSON
            70. PERCENTILE.EXC
            71. PERCENTILE.INC
            72. PERCENTRANK.EXC
            73. PERCENTRANK.INC
            74. PERMUT
            75. PERMUTATIONA
            76. PHI
            77. POISSON.DIST
            78. PROB
            79. QUARTILE.EXC
            80. QUARTILE.INC
            81. RANK.AVG
            82. RANK.EQ
            83. RSQ
            84. SKEW
            85. SKEW.P
            86. SLOPE
            87. SMALL
            88. STANDARDIZE
            89. STDEV.P
            90. STDEV.S
            91. STDEVA
            92. STDEVPA
            93. STEYX
            94. T.DIST
            95. T.DIST.2T
            96. T.DIST.RT
            97. T.INV
            98. T.INV.2T
            99. T.TEST
            100. TREND
            101. TRIMMEAN
            102. VAR.P
            103. VAR.S
            104. VARA
            105. VARPA
            106. WEIBULL.DIST
            107. Z.TEST
          11. Text Functions
            1. ASC
            2. BAHTTEXT
            3. CHAR
            4. CLEAN
            5. CODE
            6. CONCAT
            7. CONCATENATE
            8. DBCS
            9. DOLLAR
            10. EXACT
            11. FIND
            12. FIXED
            13. LEFT
            14. LEN
            15. LOWER
            16. MID
            17. OBJECT
            18. PROPER
            19. REPLACE
            20. REPT
            21. RIGHT
            22. SEARCH
            23. SEARCHB
            24. SUBSTITUTE
            25. T
            26. TEXT
            27. TEXTAFTER
            28. TEXTBEFORE
            29. TEXTJOIN
            30. TEXTSPLIT
            31. TRIM
            32. UNICHAR
            33. UNICODE
            34. UPPER
            35. VALUE
          12. Web Functions
            1. ENCODEURL
            2. FILTERJSON
            3. WEBSERVICE
          13. Compatibility Functions
            1. BETADIST
            2. BETAINV
            3. BINOMDIST
            4. CHIDIST
            5. CHIINV
            6. CHITEST
            7. CONFIDENCE
            8. COVAR
            9. CRITBINOM
            10. EXPONDIST
            11. FDIST
            12. FLOOR
            13. FTEST
            14. GAMMADIST
            15. GAMMAINV
            16. HYPGEOMDIST
            17. LOGINV
            18. LOGNORMDIST
            19. MODE
            20. NEGBINOMDIST
            21. NORMDIST
            22. NORMINV
            23. NORMSDIST
            24. NORMSINV
            25. PERCENTILE
            26. PERCENTRANK
            27. POISSON
            28. QUARTILE
            29. RANK
            30. STDEV
            31. STDEVP
            32. TDIST
            33. TINV
            34. TTEST
            35. VAR
            36. VARP
            37. WEIBULL
            38. ZTEST
      2. PQL Language
        1. Action Library (PQL)
          1. Cross-Model Functions
            1. DimensionCaption
            2. DimensionUniqueName
            3. HierarchyCaption
            4. HierarchyUniqueName
            5. MemberCaption
            6. MemberKey
            7. MemberUniqueName
            8. SourceMember
            9. TargetMember
          2. Jump Functions
            1. Captions
            2. CellValue
            3. ItemExists
            4. UniqueNames
        2. Common Library (PQL)
          1. Date-Time Functions
            1. AddDays
            2. AddHours
            3. AddMinutes
            4. AddMonths
            5. AddQuarters
            6. AddWeeks
            7. AddYears
            8. CreateDate
            9. Date
            10. DateDiff
            11. DateFormat
            12. DateTime
            13. DateToTimeStamp
            14. DayNumber
            15. DayOfYear
            16. Hour
            17. Minute
            18. Month
            19. MonthNumber
            20. Quarter
            21. QuarterNumber
            22. Second
            23. StringToDate
            24. StringtoDateTime
            25. TimeStampToDate
            26. Week
            27. WeekNumber
            28. Year
          2. Formats Functions
            1. AutoFormat
            2. CurrencyDollars0
            3. CurrencyDollars2
            4. CurrencyEuros0
            5. CurrencyEuros2
            6. CurrencyPounds0
            7. CurrencyPounds2
            8. CurrencyRands0
            9. CurrencyRands2
            10. CurrencyShekels0
            11. CurrencyShekels2
            12. CurrencySwissFrancs0
            13. CurrencySwissFrancs2
            14. DateAmerican
            15. DateTimeAmerican
            16. DateTimeUniversal
            17. DateTimeWestern
            18. DateUniversal
            19. DateWestern
            20. Number0
            21. Number1
            22. Number2
            23. NumberBillions
            24. NumberMillions
            25. NumberThousands
            26. Percent0
            27. Percent1
            28. Percent2
          3. Geo Functions
            1. GeoDistance
          4. Identity Functions
            1. ApplicationCulture
            2. UserAdAccount
            3. UserAdDomain
            4. UserCustomData
            5. UserEmail
            6. UserFirstName
            7. UserLastName
            8. UserName
            9. UserPrincipalName
            10. UserPrincipalNameAlt
            11. UserProxyAccount
            12. UserProxyAccount2
            13. UserRoles
            14. UserRolesSet
            15. UserTenant
          5. Logical Functions
            1. Case
            2. Equals
            3. If
            4. IfNull
            5. IsNAN
            6. Loop
            7. LoopVector
            8. NotEquals
            9. Switch
          6. Math Functions
            1. Absolute
            2. ArcCos
            3. ArcSin
            4. ArcTan
            5. Ceiling
            6. Coalesce
            7. ConvertToNumber
            8. Cos
            9. Ctan
            10. Divide
            11. E
            12. Exponent
            13. Floor
            14. Ln
            15. Log
            16. Log10
            17. Log2
            18. Multiply
            19. PI
            20. Power
            21. Random
            22. RandomDouble
            23. RemoveBlanks
            24. RGB
            25. Round
            26. Sin
            27. Tan
            28. ToDegrees
            29. ToRadians
          7. Statistical Functions
            1. Average
            2. Correlation
            3. Covariance
            4. DataSet
            5. IndexOfMax
            6. IndexOfMin
            7. Maximum
            8. Median
            9. Minimum
            10. PercentileRank
            11. Rank
            12. StandardDeviation
            13. Sum
          8. String Functions
            1. Contains
            2. EndsWith
            3. FindByPattern
            4. Format
            5. HasItem
            6. IndexOf
            7. Left
            8. Length
            9. LLM
            10. Replace
            11. Right
            12. StartsWith
            13. StringJoin
            14. SubString
            15. ToLower
            16. ToProper
            17. ToString
            18. ToUpper
            19. Trim
            20. TrimLeft
            21. TrimRight
            22. UrlDecode
            23. UrlEncode
        3. Dynamic Library (PQL)
          1. Column Functions
            1. DataSetColumn
            2. DataSetColumnRange
            3. FindColumnNumber
            4. LastColumn
            5. LookupMaxColumn
            6. LookupMinColumn
            7. NumberOfColumns
            8. TotalColumn
          2. Grid Functions
            1. CountAvg
            2. CountPercentile
            3. Data
            4. Forecast
            5. ForecastPercent
            6. ForecastValue
            7. FormattedData
            8. GridCountAvg
            9. GridCountPercentile
            10. IsCellEmpty
            11. IsCellValid
            12. IsEmptyQuery
            13. IsQueryValid
            14. Label
            15. LinearTrendSlopeValue
            16. MaxGrid
            17. MinGrid
            18. NumberOfCells
            19. Outlier
            20. TotalGrid
          3. Markup Functions
            1. Bold
            2. Bullet
            3. FontFormat
            4. HyperLink
            5. Image
            6. Italics
            7. LineBreak
            8. OrderedList
            9. Underline
            10. UnorderedList
          4. Row Functions
            1. DataSetRow
            2. DataSetRowRange
            3. FindRowNumber
            4. LastRow
            5. LookupMaxRow
            6. LookupMinRow
            7. NumberOfRows
            8. TotalRow
          5. Smart Functions
            1. SmartInsights
            2. SmartInsightsCategorical
        4. Granular Library (PQL)
          1. Date-Time Functions
            1. AddDays
            2. AddHours
            3. AddMinutes
            4. AddMonths
            5. AddQuarters
            6. AddWeeks
            7. AddYears
            8. Age
            9. Date
            10. DateDiff
            11. DateFormat
            12. DayNumber
            13. DayOfWeekName
            14. DayOfWeekNumber
            15. DayOfYear
            16. Hour
            17. Minute
            18. Month
            19. MonthName
            20. MonthNumber
            21. Now
            22. Quarter
            23. QuarterNumber
            24. Second
            25. ToDate
            26. Today
            27. Week
            28. WeekNumber
            29. Year
          2. Identity Functions
            1. UserAdAccount
            2. UserAdDomain
            3. UserCustomData
            4. UserEmail
            5. UserFirstName
            6. UserLastName
            7. UserName
            8. UserPrincipalName
            9. UserPrincipalNameAlt
            10. UserProxyAccount
            11. UserProxyAccount2
            12. UserRoles
            13. UserTenant
          3. Logical Functions
            1. Case
            2. If
            3. In
            4. IsNull
            5. Not
            6. NullIfEqual
            7. Switch
          4. Math Functions
            1. Abs
            2. ArcCos
            3. ArcSin
            4. ArcTan
            5. Bin
            6. Ceiling
            7. Coalesce
            8. Cos
            9. Ctan
            10. E
            11. Exp
            12. Floor
            13. Log
            14. Log10
            15. Mod
            16. PI
            17. Power
            18. Random
            19. Round
            20. Sin
            21. Sqrt
            22. Tan
            23. ToDecimal
            24. ToDegrees
            25. ToInteger
            26. ToRadians
          5. String Functions
            1. Concat
            2. Contains
            3. EndsWith
            4. IndexOf
            5. Left
            6. Length
            7. Replace
            8. Right
            9. StartsWith
            10. SubString
            11. ToLower
            12. ToString
            13. ToUpper
            14. Trim
            15. WordCount
        5. Semantic Library (PQL)
          1. Aggregate Functions
            1. Average
            2. Count
            3. CumulativeTimeSum
            4. DistinctCount
            5. FirstChild
            6. FirstQuartile
            7. LastChild
            8. Maximum
            9. Median
            10. Minimum
            11. Sum
            12. Text
            13. ThirdQuartile
          2. Date-Time Functions
            1. AddDays
            2. AddMonths
            3. AddQuarters
            4. AddWeeks
            5. AddYears
            6. ClosingPeriod
            7. CreateDate
            8. CurrentPeriod
            9. FullMonth
            10. FullQuarter
            11. FullWeek
            12. Fullyear
            13. MTD
            14. OpeningPeriod
            15. ParallelPeriod
            16. ParallelPeriods
            17. QTD
            18. WTD
            19. YTD
          3. Financial Functions
            1. Irr
            2. Npv
            3. Xirr
            4. Xnpv
          4. Hierarchical Functions
            1. AllDescendants
            2. Ancestor
            3. Ascendants
            4. Children
            5. Cousin
            6. Descendants
            7. FirstChild
            8. FirstSibling
            9. GrandParent
            10. IsAncestor
            11. IsLeaf
            12. IsSibling
            13. LastChild
            14. LastSibling
            15. LeafDescendants
            16. Level
            17. Levels
            18. Ordinal
            19. Parent
            20. Siblings
          5. List Functions
            1. AllMembers
            2. BottomCount
            3. BottomPercent
            4. BottomSum
            5. Empty
            6. Except
            7. Filter
            8. Head
            9. Intersect
            10. Leaves
            11. NonEmpty
            12. Not
            13. Order
            14. Range
            15. Subset
            16. Tail
            17. thenBy
            18. TopCount
            19. TopPercent
            20. TopSum
            21. Union
          6. Logical Functions
            1. HasChildren
            2. HasDataPoint
            3. HasDataPoints
            4. If
            5. ListContainsAll
            6. ListContainsAny
            7. Switch
          7. Member Functions
            1. ClosingElement
            2. CurrentMember
            3. DefaultMember
            4. FirstElement
            5. GetElement
            6. Lag
            7. LastElement
            8. Lead
            9. NextMember
            10. Offset
            11. OpeningElement
            12. PrevMember
          8. Statistical Functions
            1. Aggregate
            2. Average
            3. Correlation
            4. Count
            5. Covariance
            6. CovarianceP
            7. ExpRegA
            8. ExpRegB
            9. ExpRegPoint
            10. ExpRegR2
            11. LinRegIntercept
            12. LinRegPoint
            13. LinRegR2
            14. LinRegSlope
            15. LogRegA
            16. LogRegB
            17. LogRegPoint
            18. LogRegR2
            19. Maximum
            20. Median
            21. Minimum
            22. Multiply
            23. Percentile
            24. PowerRegA
            25. PowerRegB
            26. PowerRegPoint
            27. PowerRegR2
            28. Rank
            29. Sample
            30. SamplePercent
            31. Stdev
            32. StdevP
            33. Sum
            34. Variance
            35. VarianceP
          9. String Functions
            1. Caption
            2. Contains
            3. EndsWith
            4. Equals
            5. ModelCulture
            6. StartsWith
            7. StrToDate
            8. StrToMember
            9. StrToSet
            10. UniqueName
        6. Spreadsheet Library (PQL)
          1. Pyramid Functions
            1. DATA
            2. MEMBER
            3. PARAMETER
            4. SLICER
            5. SLICERCAPTION
          2. Database Functions
            1. DAVERAGE
            2. DCOUNT
            3. DCOUNTA
            4. DGET
            5. DMAX
            6. DMIN
            7. DPRODUCT
            8. DSTDEV
            9. DSTDEVP
            10. DSUM
            11. DVAR
            12. DVARP
          3. Date & Time Functions
            1. DATE
            2. DATEDIF
            3. DATEVALUE
            4. DAY
            5. DAYS
            6. DAYS360
            7. EDATE
            8. EOMONTH
            9. HOUR
            10. ISOWEEKNUM
            11. MINUTE
            12. MONTH
            13. NETWORKDAYS
            14. NETWORKDAYS.INTL
            15. NOW
            16. SECOND
            17. TIME
            18. TIMEVALUE
            19. TODAY
            20. WEEKDAY
            21. WEEKNUM
            22. WORKDAY
            23. WORKDAY.INTL
            24. YEAR
            25. YEARFRAC
          4. Engineering Functions
            1. BESSELI
            2. BESSELJ
            3. BESSELK
            4. BESSELY
            5. BIN2DEC
            6. BIN2HEX
            7. BIN2OCT
            8. BITAND
            9. BITLSHIFT
            10. BITOR
            11. BITRSHIFT
            12. BITXOR
            13. COMPLEX
            14. CONVERT
            15. DEC2BIN
            16. DEC2HEX
            17. DEC2OCT
            18. DELTA
            19. ERF
            20. ERF.PRECISE
            21. ERFC
            22. ERFC.PRECISE
            23. GESTEP
            24. HEX2BIN
            25. HEX2DEC
            26. HEX2OCT
            27. IMABS
            28. IMAGINARY
            29. IMARGUMENT
            30. IMCONJUGATE
            31. IMCOS
            32. IMCOSH
            33. IMCOT
            34. IMCSC
            35. IMCSCH
            36. IMDIV
            37. IMEXP
            38. IMLN
            39. IMLOG10
            40. IMLOG2
            41. IMPOWER
            42. IMPRODUCT
            43. IMREAL
            44. IMSEC
            45. IMSECH
            46. IMSIN
            47. IMSINH
            48. IMSQRT
            49. IMSUB
            50. IMSUM
            51. IMTAN
            52. OCT2BIN
            53. OCT2DEC
            54. OCT2HEX
          5. Financial Functions
            1. ACCRINT
            2. ACCRINTM
            3. AMORDEGRC
            4. AMORLINC
            5. COUPDAYBS
            6. COUPDAYS
            7. COUPDAYSNC
            8. COUPNCD
            9. COUPNUM
            10. COUPPCD
            11. CUMIPMT
            12. CUMPRINC
            13. DB
            14. DDB
            15. DISC
            16. DOLLARDE
            17. DOLLARFR
            18. DURATION
            19. EFFECT
            20. FV
            21. FVSCHEDULE
            22. INTRATE
            23. IPMT
            24. IRR
            25. ISPMT
            26. MDURATION
            27. MIRR
            28. NOMINAL
            29. NPER
            30. NPV
            31. ODDFPRICE
            32. ODDFYIELD
            33. ODDLPRICE
            34. ODDLYIELD
            35. EURO
            36. EUROCONVERT
            37. PDURATION
            38. PMT
            39. PPMT
            40. PRICE
            41. PRICEDISC
            42. PRICEMAT
            43. PV
            44. RATE
            45. RECEIVED
            46. RRI
            47. SLN
            48. SYD
            49. TBILLEQ
            50. TBILLPRICE
            51. TBILLYIELD
            52. VDB
            53. XIRR
            54. XNPV
            55. YIELD
            56. YIELDDISC
            57. YIELDMAT
          6. Information Functions
            1. ERROR.TYPE
            2. ISBLANK
            3. ISERR
            4. ISERROR
            5. ISEVEN
            6. ISFORMULA
            7. ISLOGICAL
            8. ISNA
            9. ISNONTEXT
            10. ISNUMBER
            11. ISODD
            12. ISOMITTED
            13. ISREF
            14. ISTEXT
            15. N
            16. NA
            17. SHEET
            18. SHEETS
            19. TYPE
          7. Logical Functions
            1. AND
            2. BYCOL
            3. BYROW
            4. IF
            5. IFERROR
            6. IFNA
            7. IFS
            8. LAMBDA
            9. LET
            10. MAKEARRAY
            11. MAP
            12. NOT
            13. OR
            14. REDUCE
            15. SCAN
            16. SWITCH
            17. XOR
          8. Lookup Functions
            1. ADDRESS
            2. AREAS
            3. CHOOSE
            4. CHOOSECOLS
            5. CHOOSEROWS
            6. COLUMN
            7. COLUMNS
            8. DROP
            9. EXPEND
            10. FILTER
            11. FORMULATEXT
            12. HLOOKUP
            13. HSTACK
            14. HYPERLINK
            15. INDEX
            16. INDIRECT
            17. LOOKUP
            18. MATCH
            19. OFFSET
            20. ROW
            21. ROWS
            22. SORT
            23. SORTBY
            24. TOCOL
            25. TOROW
            26. TRANSPOSE
            27. UNIQUE
            28. VLOOKUP
            29. VSTACK
            30. WRAPCOLS
            31. WRAPROWS
            32. XLOOKUP
            33. XMATCH
          9. Math & Trig Functions
            1. ABS
            2. ACOS
            3. ACOSH
            4. ACOT
            5. ACOTH
            6. AGGREGATE
            7. ARABIC
            8. ASIN
            9. ASINH
            10. ATAN
            11. ATAN2
            12. ATANH
            13. BASE
            14. CEILING
            15. CEILING.MATH
            16. CEILING.PRECISE
            17. COMBIN
            18. COMBINA
            19. COS
            20. COSH
            21. COT
            22. COTH
            23. CSC
            24. CSCH
            25. DECIMAL
            26. DEGREES
            27. EVEN
            28. EXP
            29. FACT
            30. FACTDOUBLE
            31. FLOOR.MATH
            32. FLOOR.PRECISE
            33. GCD
            34. INT
            35. ISO.CEILING
            36. LCM
            37. LN
            38. LOG
            39. LOG10
            40. MDETERM
            41. MINVERSE
            42. MMULT
            43. MOD
            44. MROUND
            45. MULTINOMIAL
            46. ODD
            47. PI
            48. POWER
            49. PRODUCT
            50. QUOTIENT
            51. RADIANS
            52. RAND
            53. RANDARRAY
            54. RANDBETWEEN
            55. ROMAN
            56. ROUND
            57. ROUNDDOWN
            58. ROUNDUP
            59. SEC
            60. SECH
            61. SEQUENCE
            62. SERIESSUM
            63. SIGN
            64. SIN
            65. SINH
            66. SQRT
            67. SQRTPI
            68. SUBTOTAL
            69. SUM
            70. SUMIF
            71. SUMIFS
            72. SUMPRODUCT
            73. SUMSQ
            74. SUMX2MY2
            75. SUMX2PY2
            76. SUMXMY2
            77. TAN
            78. TANH
            79. TRUNC
          10. Statistical Functions
            1. AVEDEV
            2. AVERAGE
            3. AVERAGEA
            4. AVERAGEIF
            5. AVERAGEIFS
            6. BETA.DIST
            7. BETA.INV
            8. BINOM.DIST
            9. BINOM.DIST.RANGE
            10. BINOM.INV
            11. CHISQ.DIST
            12. CHISQ.DIST.RT
            13. CHISQ.INV
            14. CHISQ.INV.RT
            15. CHISQ.TEST
            16. CONFIDENCE.NORM
            17. CONFIDENCE.T
            18. CORREL
            19. COUNT
            20. COUNTA
            21. COUNTBLANK
            22. COUNTIF
            23. COUNTIFS
            24. COVARIANCE.P
            25. COVARIANCE.S
            26. DEVSQ
            27. EXPON.DIST
            28. F.DIST
            29. F.DIST.RT
            30. F.INV
            31. F.INV.RT
            32. F.TEST
            33. FINV
            34. FISHER
            35. FISHERINV
            36. FORECAST
            37. FREQUENCY
            38. GAMMA
            39. GAMMA.DIST
            40. GAMMA.INV
            41. GAMMALN
            42. GAMMALN.PRECISE
            43. GAUSS
            44. GEOMEAN
            45. GROWTH
            46. HARMEAN
            47. HYPGEOM.DIST
            48. INTERCEPT
            49. KURT
            50. LARGE
            51. LINEST
            52. LOGEST
            53. LOGNORM.DIST
            54. LOGNORM.INV
            55. MAX
            56. MAXA
            57. MAXIFS
            58. MEDIAN
            59. MIN
            60. MINA
            61. MINIFS
            62. MODE.MULT
            63. MODE.SNGL
            64. NEGBINOM.DIST
            65. NORM.DIST
            66. NORM.INV
            67. NORM.S.DIST
            68. NORM.S.INV
            69. PEARSON
            70. PERCENTILE.EXC
            71. PERCENTILE.INC
            72. PERCENTRANK.EXC
            73. PERCENTRANK.INC
            74. PERMUT
            75. PERMUTATIONA
            76. PHI
            77. POISSON.DIST
            78. PROB
            79. QUARTILE.EXC
            80. QUARTILE.INC
            81. RANK.AVG
            82. RANK.EQ
            83. RSQ
            84. SKEW
            85. SKEW.P
            86. SLOPE
            87. SMALL
            88. STANDARDIZE
            89. STDEV.P
            90. STDEV.S
            91. STDEVA
            92. STDEVPA
            93. STEYX
            94. T.DIST
            95. T.DIST.2T
            96. T.DIST.RT
            97. T.INV
            98. T.INV.2T
            99. T.TEST
            100. TREND
            101. TRIMMEAN
            102. VAR.P
            103. VAR.S
            104. VARA
            105. VARPA
            106. WEIBULL.DIST
            107. Z.TEST
          11. Text Functions
            1. ASC
            2. BAHTTEXT
            3. CHAR
            4. CLEAN
            5. CODE
            6. CONCAT
            7. CONCATENATE
            8. DBCS
            9. DOLLAR
            10. EXACT
            11. FIND
            12. FIXED
            13. LEFT
            14. LEN
            15. LOWER
            16. MID
            17. OBJECT
            18. PROPER
            19. REPLACE
            20. REPT
            21. RIGHT
            22. SEARCH
            23. SEARCHB
            24. SUBSTITUTE
            25. T
            26. TEXT
            27. TEXTAFTER
            28. TEXTBEFORE
            29. TEXTJOIN
            30. TEXTSPLIT
            31. TRIM
            32. UNICHAR
            33. UNICODE
            34. UPPER
            35. VALUE
          12. Web Functions
            1. ENCODEURL
            2. FILTERJSON
            3. WEBSERVICE
          13. Compatibility Functions
            1. BETADIST
            2. BETAINV
            3. BINOMDIST
            4. CHIDIST
            5. CHIINV
            6. CHITEST
            7. CONFIDENCE
            8. COVAR
            9. CRITBINOM
            10. EXPONDIST
            11. FDIST
            12. FLOOR
            13. FTEST
            14. GAMMADIST
            15. GAMMAINV
            16. HYPGEOMDIST
            17. LOGINV
            18. LOGNORMDIST
            19. MODE
            20. NEGBINOMDIST
            21. NORMDIST
            22. NORMINV
            23. NORMSDIST
            24. NORMSINV
            25. PERCENTILE
            26. PERCENTRANK
            27. POISSON
            28. QUARTILE
            29. RANK
            30. STDEV
            31. STDEVP
            32. TDIST
            33. TINV
            34. TTEST
            35. VAR
            36. VARP
            37. WEIBULL
            38. ZTEST
        7. Context Library (PQL)
    2. Function Elements and Syntax
      1. Function Arguments
      2. Function Return Values
      3. Operators
        1. Arithmetic Operators
        2. Comparison Operators
        3. Logical Operators
      4. Data Object Syntax
        1. Dimensions and Tables
        2. Hierarchies and Columns
        3. Members and Elements
        4. Values and Measures
        5. Data Points or Tuples
        6. Lists and Sets
        7. SelfCalc
    3. Script Editors
      1. PQL Editor
  2. Extensibility
    1. Embedding
      1. Embed Flows
      2. Examples
      3. Embed Code Examples
      4. Embed Troubleshooting
      5. Embed API
        1. Embed API Objects
        2. PyramidEmbedClient
          1. Login
          2. LoginWindowsAuth
          3. LoginSamlAuth
          4. LoginOpenIdAuth
          5. Authentication Failure Callback
          6. Init
          7. Embed
          8. Hub
          9. QuickEmbed
          10. SetAuthToken
          11. GetAuthToken
          12. Host
          13. IsClientLoaded
          14. IsLoggedIn
          15. Content Embedding
            1. EmbedOptions
              1. QuickEmbedOptions
              2. Export Types
            2. Filter
              1. Add (filters)
              2. AddUniqueName (filters)
            3. Target
              1. Add (targets)
            4. AppStyles
            5. EmbeddedResult
              1. GoToSlide
              2. EmbeddedType
              3. Query
              4. Hierarchy
              5. Member
          16. Hub Embedding
            1. Hub (Object)
              1. HubEmbedOptions
                1. Style
                2. Hub AppStyles
      6. Raw API (Embed API v1.0)
        1. Using Raw API
        2. Raw Code Embedding
    2. Direct Load (via URL)
      1. URL Parameterization
    3. External Parameterization
      1. Target Parameterization for Presentations
    4. Direct Launch (via URL)
  3. APIs
    1. Main API and SDKs
      1. Using REST
      2. Using SDKs
      3. REST API HTTP Status Codes
      4. Authentication APIs Overview
      5. API 3.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addScientistProfile
          5. addUserToRole
          6. addUsersToRole
          7. addViewerProfile
          8. changeUserLicense
          9. createRole
          10. createRoles
          11. createTenant
          12. createTenants
          13. createUsers
          14. createUsersFromSearch
          15. deleteProfile
          16. deleteRole
          17. deleteTenants
          18. deleteUser
          19. findRoles
          20. getAllAnalystProfiles
          21. getAllProfessionalProfiles
          22. getAllRoles
          23. getAllScientistProfiles
          24. getAllTenants
          25. getAllViewerProfiles
          26. getDefaultTenant
          27. getLicenseCount
          28. getLicenseExpirationDate
          29. getLicenseValidationStatus
          30. getMe
          31. getProfileForUser
          32. getPublicRoles
          33. getPublicRolesByTenant
          34. getRoleById
          35. getRoleGroups
          36. getRolesByUser
          37. getRolesbyProfile
          38. getTenantByName
          39. getTenantUnusedLicenseCount
          40. getTenantUsersByUserType
          41. getUser
          42. getUserByExternalId
          43. getUserLastLogin
          44. getUserStatusById
          45. getUserStatusByName
          46. getUsersByCurrentTenant
          47. getUsersByName
          48. getUsersByRole
          49. getUsersByTenant
          50. searchExternalGroups
          51. searchExternalUsers
          52. searchGroupUsers
          53. searchUserGroups
          54. setUserAdministrationLevel
          55. toggleUserStatus
          56. updateDomainAdminPermissions
          57. updateRole
          58. updateRoleGroups
          59. updateRoleProfiles
          60. updateTenant
          61. updateTenantSeats
          62. updateUserRoles
          63. updateUsers
          64. updateUsersFromSearch
          65. updateUsersPhones
        2. Analytics APIs
          1. createDiscover
          2. extractNlpQueryResult
          3. extractQueryResult
          4. getFormula
          5. getList
          6. getParameterElements
          7. setFormula
          8. setList
        3. Authentication APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserSAML
          10. authenticateUserWindows
        4. Content APIs
          1. addItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteHub
          10. deleteItems
          11. deleteTag
          12. exportContent
          13. exportHub
          14. findContentItem
          15. findHub
          16. findItemsByTag
          17. findItemsByTagName
          18. getAllItemTags
          19. getAllItemsCreatedByUser
          20. getAllTags
          21. getAllTagsData
          22. getAutoRecommendedItems
          23. getContentItemMetaData
          24. getFavoriteItems
          25. getFolderItems
          26. getItem
          27. getItemRoles
          28. getItemRolesID
          29. getMostUsedItems
          30. getPrivateFolderForUser
          31. getRecentItems
          32. getRecommendedItems
          33. getTagData
          34. getTenantPublicOrGroupFolder
          35. getUserGroupFolders
          36. getUserGroupRootFolder
          37. getUserPrivateFolder
          38. getUserPrivateRootFolder
          39. getUserPublicFolders
          40. getUserPublicRootFolder
          41. importContent
          42. importHub
          43. moveItems
          44. purgeContentItems
          45. removeItemsFromFavorites
          46. removeRolesFromItem
          47. removeTagFromItem
          48. renameItem
          49. restoreDeletedItems
        5. Datasources APIs
          1. addHierarchyOverlay
          2. addHierarchySecurity
          3. addMeasureOverlay
          4. addMeasureSecurity
          5. addMembersSecurity
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. addXtenderDataServers
          12. addXtenderDatabases
          13. changeDataSource
          14. changeDataSources
          15. createDataServer
          16. createDataServers
          17. deleteDataBase
          18. deleteDataSource
          19. deleteHierarchyOverlay
          20. deleteHierarchySecurity
          21. deleteMaterializedModel
          22. deleteMeasureOverlay
          23. deleteMeasureSecurity
          24. deleteMembersSecurity
          25. deleteRolesFromDatabase
          26. deleteRolesFromModel
          27. deleteRolesFromServer
          28. deleteXtenderDataServers
          29. deleteXtenderDatabases
          30. executeMasterFlow
          31. exportDataCatalog
          32. exportModel
          33. findDatabaseByName
          34. findModelConnection
          35. findServerByName
          36. getAllConnectionStrings
          37. getDataServerDetails
          38. getDataSourcesByTenant
          39. getDataSourcesByUserId
          40. getDatasourceUsedTables
          41. getHierarchyOverlay
          42. getHierarchySecurity
          43. getImdbResources
          44. getItemConnectionString
          45. getMasterFlowProgressLogs
          46. getMasterFlowProgressUpdate
          47. getMasterFlowVariables
          48. getMaterializedModelProperties
          49. getMeasureOverlay
          50. getMeasureSecurity
          51. getMemberSecurity
          52. getModelStructure
          53. getPulseNodesForTenant
          54. getRolesByDataBase
          55. getRolesByModel
          56. getRolesByServer
          57. getSourceByNode
          58. getTargetByNode
          59. getUserDataCatalog
          60. getXtenderDataServers
          61. getXtenderDatabases
          62. importModel
          63. recognizeDataBase
          64. recognizeModel
          65. togglePauseDatasource
          66. updateDataCatalog
          67. updateDataFlowNodeSchemas
          68. updateMaterializedModelProperties
          69. updateModelName
          70. updateModelProcessDate
          71. updateSourceNodeConnection
          72. updateTargetNodeConnection
          73. updateVariableConnection
          74. updateVariableValue
          75. validateMasterFlow
        6. Notification APIs
          1. getNotificationIndicators
          2. getNotificationIndicatorsAdminView
          3. readServersMetrics
        7. Tasks APIs
          1. deleteSchedule
          2. deleteSchedules
          3. findSchedule
          4. getExecutions
          5. getScheduleExecutionStatus
          6. getSchedulesForUser
          7. getTaskData
          8. getTaskOutputs
          9. getTaskOutputsForUser
          10. getTasks
          11. getTasksIds
          12. reRunTask
          13. resumeSchedule
          14. runOnDemandSchedules
          15. runSchedule
          16. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. getThemeList
          5. importTheme
      6. API 2.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addProfile
          5. addScientistProfile
          6. addUserToRole
          7. addUsersToRole
          8. addViewerProfile
          9. changeLicenseForUser
          10. changeRoleAdGroupMembership
          11. createRole
          12. createRoles
          13. createTenant
          14. createTenants
          15. createUserAd
          16. createUserDb
          17. createUserOpenId
          18. createUserSaml
          19. createUsersAd
          20. createUsersDb
          21. createUsersOpenId
          22. createUsersSaml
          23. deleteProfile
          24. deleteRole
          25. deleteTenants
          26. deleteUser
          27. getAllNonPrivateRoles
          28. getAllNonPrivateRolesByTenant
          29. getAllNonPrivateRolesIDByTenant
          30. getAllProfiles
          31. getAllProfilesByClientLicenseType
          32. getAllProfilesByClientLicenseTypeByTenantId
          33. getAllProfilesByTenantId
          34. getAllRoles
          35. getAllRolesByProfileId
          36. getAllRolesByUser
          37. getAllTenants
          38. getAllUsersByCurrentTenant
          39. getAllUsersByTenant
          40. getAllUsersDataByTenantAndLicenceType
          41. getAvailableTenantLicenseCount
          42. getDefaultTenant
          43. getGroupsByRole
          44. getLicenseCount
          45. getLicenseCount2
          46. getLicenseExpirationDate
          47. getLicenseValidationStatus
          48. getMe
          49. getPrivateProfileIdForUser
          50. getRoleById
          51. getRolesByName
          52. getTenantByName
          53. getUser
          54. getUserByOpenIdPrincipalName
          55. getUserBySamlPrincipalName
          56. getUserLastLogin
          57. getUserStatusById
          58. getUserStatusByName
          59. getUsersByName
          60. getUsersByRole
          61. searchAdGroups
          62. searchAdGroupsForUser
          63. searchAdUsers
          64. searchAdUsersForGroups
          65. setUserAdministrationLevel
          66. toggleEnableUser
          67. updateDomainAdminPermissions
          68. updateRolesByProfileId
          69. updateTenant
          70. updateTenantSeats
          71. updateUserAd
          72. updateUserDb
          73. updateUserOpenId
          74. updateUserRoles
          75. updateUserSaml
          76. updateUsersAd
          77. updateUsersDb
          78. updateUsersOpenId
          79. updateUsersPhones
          80. updateUsersSaml
        2. Auth APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserOPENIDAlt
          10. authenticateUserSAML
          11. authenticateUserSAMLAlt
          12. authenticateUserWindows
        3. Content APIs
          1. addContentItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteTag
          10. exportContent
          11. exportContent2
          12. exportHub
          13. findContentItem
          14. findItemsByTagId
          15. findItemsByTagName
          16. getAllItemTags
          17. getAllItemsCreatedByUser
          18. getAllTags
          19. getAllTagsData
          20. getAllUserContentItems
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getContentItemSecurityRoles
          24. getContentItemSecurityRolesID
          25. getFavoriteItems
          26. getFolderItems
          27. getItem
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getPrivateRootFolder
          31. getPublicOrGroupFolderByTenantId
          32. getRecentItems
          33. getRecommendedItems
          34. getTag
          35. getUserGroupFolders
          36. getUserGroupRootFolder
          37. getUserPrivateFolder
          38. getUserPrivateRootFolder
          39. getUserPublicFolders
          40. getUserPublicRootFolder
          41. importContent
          42. importHub
          43. moveItems
          44. purgeContentItems
          45. removeContentItemsFromFavorites
          46. removeRolesFromItem
          47. removeTagFromItem
          48. renameItem
          49. restoreSoftDeletedContentItems
          50. softDeleteContentItems
        4. Datasources APIs
          1. addHierarchyOverlayToModel
          2. addHierarchySecurityToModel
          3. addMeasureOverlayToModel
          4. addMeasureSecurityToModel
          5. addMembersSecurityToModel
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlayFromModel
          18. deleteHierarchySecurityFromModel
          19. deleteMaterializedModel
          20. deleteMeasureOverlayFromModel
          21. deleteMeasureSecurityFromModel
          22. deleteMembersSecurityFromModel
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportMaterializedModelDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelByName
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataModelStructure
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchySecurity
          38. getItemConnectionString
          39. getMasterFlowProgressUpdate
          40. getMasterFlowVariables
          41. getMeasureSecurity
          42. getMemberSecurity
          43. getModelHierarchyOverlay
          44. getModelMeasureOverlay
          45. getPulseNodesForTenant
          46. getRolesByDataBase
          47. getRolesByModel
          48. getRolesByServer
          49. getServerDataById
          50. getSourceByNodeId
          51. getTargetByNodeId
          52. getUserDataCatalog
          53. importMaterializedModelDataCatalog
          54. importModel
          55. recognizeDataBase
          56. recognizeModel
          57. searchConnectionString
          58. updateDataFlowNodeSchemas
          59. updateModelName
          60. updateModelProcessDate
          61. updateSourceNodeConnection
          62. updateTargetNodeConnection
          63. updateVariableConnection
          64. updateVariableValue
          65. validateMasterFlow
        5. Notification APIs
          1. getNotificationIndicators
        6. Query APIs
          1. extractNlpQueryResult
          2. extractQueryResult
          3. getParameterElements
        7. Tasks APIs
          1. deleteSchedule
          2. findSchedule
          3. getExecutions
          4. getScheduleExecutionStatus
          5. getSchedulesForUser
          6. getTaskData
          7. getTaskOutputs
          8. getTaskOutputsForUser
          9. getTasks
          10. getTasksIds
          11. reRunTask
          12. resumeSchedule
          13. runOnDemandSchedules
          14. runSchedule
          15. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      7. API Objects and Enumerations
        1. API Object Definitions
          1. AddHierarchyOverlayApiObject
          2. AddMeasureOverlayApiObject
          3. AddUserRoleData
          4. AddUsersRoleData
          5. AdditionalServerProperties
          6. AdminMultiTenantData
          7. AdminTypeApiData
          8. AnalystProfileApiData
          9. AnalyticsPermissions
          10. ApiResultLicenseStatus
          11. ApiResultTaskStatus
          12. AttributeTranslation
          13. BaseUserOpenIdCredentials
          14. BaseUserSamlCredentials
          15. CartesianCategoriesDropZone
          16. CartesianCategoriesHierarchyChip
          17. CartesianColorChip
          18. CartesianColorDropZone
          19. CartesianColorHierarchyChip
          20. CartesianColorMeasureChip
          21. CartesianFilterChip
          22. CartesianFilterDropZone
          23. CartesianFilterHierarchyChip
          24. CartesianFilterValuesChip
          25. CartesianLabelsChip
          26. CartesianLabelsDropZone
          27. CartesianLabelsHierarchyChip
          28. CartesianLabelsMeasureChip
          29. CartesianMotionDropZone
          30. CartesianMotionHierarchyChip
          31. CartesianShapeChip
          32. CartesianShapeDropZone
          33. CartesianShapeHierarchyChip
          34. CartesianShapeMeasureChip
          35. CartesianSizeDropZone
          36. CartesianSizeMeasureChip
          37. CartesianTooltipChip
          38. CartesianTooltipDropZone
          39. CartesianTooltipHierarchyChip
          40. CartesianTooltipMeasureChip
          41. CartesianTrellisHorizontalChip
          42. CartesianTrellisHorizontalDropZone
          43. CartesianTrellisHorizontalHierarchyChip
          44. CartesianTrellisHorizontalValuesChip
          45. CartesianTrellisVerticalChip
          46. CartesianTrellisVerticalDropZone
          47. CartesianTrellisVerticalHierarchyChip
          48. CartesianTrellisVerticalValuesChip
          49. CartesianValuesDropZone
          50. CartesianValuesMeasureChip
          51. CartesianValuesVisualTypes
          52. CartesianVisual
          53. ChangeItemDescriptionData
          54. ChangeUserLicenseObject
          55. ConnStringDscApiObject
          56. ConnectedItemsSearchCriteria
          57. ConnectionSearchCriteria
          58. ConnectionStringData
          59. ConnectionStringProperties
          60. ContentSearchParamsObject
          61. CreateRoleData
          62. CreateUserAdObject
          63. CreateUserDbObject
          64. CreateUserFromSearchObject
          65. CreateUserObject
          66. CreateUserOpenIdObject
          67. CreateUserSamlObject
          68. CreatedThemeResult
          69. DataBaseRecognitionObject
          70. DataCatalogDimension
          71. DataCatalogHierarchy
          72. DataCatalogHierarchyLevel
          73. DataCatalogItem
          74. DataCatalogMeasure
          75. DataCatalogModelMetadata
          76. DataCatalogProperty
          77. DataCatalogUpdateData
          78. DataSourceTableResult
          79. DataSourceUsedTablesResult
          80. DeleteHierarchyOverlayApiObject
          81. DeleteMeasureOverlayApiObject
          82. DeleteTenantApiData
          83. DiscoverData
          84. DiscoverDataCatalog
          85. DomainAdminPermissionAPIObject
          86. DomainAdminPermissions
          87. DomainSecurityObject
          88. DscApiData
          89. ElementSelectionData
          90. EnumerationOutput
          91. ErrorMessage
          92. ExecuteMasterFlowObject
          93. ExecuteMasterFlowResult
          94. ExecuteScheduleApiData
          95. ExecutionSettings
          96. ExecutionViewData
          97. ExportContentApiData
          98. ExportData
          99. ExportOptions
          100. ExternalGroupIdentifier
          101. ExternalGroupModel
          102. ExternalParameters
          103. ExternalSearchObject
          104. ExternalUserIdentifier
          105. ExternalUserModel
          106. FailedItemId
          107. FilterParameter
          108. FolderTenantObject
          109. FormulaData
          110. FtpSettings
          111. GeneralModelProperties
          112. GetFolderItemsObject
          113. GetItemParamsObject
          114. GetOverlaySecurityObject
          115. GridColorChip
          116. GridColorDropZone
          117. GridColorHierarchyChip
          118. GridColorMeasureChip
          119. GridColsChip
          120. GridColsDropZone
          121. GridColsHierarchyChip
          122. GridColsValuesChip
          123. GridFilterChip
          124. GridFilterDropZone
          125. GridFilterHierarchyChip
          126. GridFilterValuesChip
          127. GridIndicatorDropZone
          128. GridIndicatorMeasureChip
          129. GridRowsChip
          130. GridRowsDropZone
          131. GridRowsHierarchyChip
          132. GridRowsValuesChip
          133. GridSizeDropZone
          134. GridSizeMeasureChip
          135. GridTooltipChip
          136. GridTooltipDropZone
          137. GridTooltipHierarchyChip
          138. GridTooltipMeasureChip
          139. GridValuesDropZone
          140. GridValuesMeasureChip
          141. GridVisual
          142. HierarchyElementSelection
          143. HierarchyMeasureSecurity
          144. HierarchyMeasureSecurityApiObject
          145. HierarchyOverlayData
          146. HierarchyOverlayToDeleteData
          147. HubApiObject
          148. ImdbResourceQuery
          149. ImdbResourceResult
          150. ImportApiResultObject
          151. ImportMaterializedModelObject
          152. ItemId
          153. ItemParentApiData
          154. ItemRolePair
          155. ItemRolesForRemoval
          156. ItemRolesToBeAdded
          157. ItemsForFavorites
          158. ItemsToCopy
          159. ItemsToMove
          160. LdapGroupDetails
          161. LdapGroupIdentifier
          162. LdapSearchObject
          163. LdapUserObject
          164. LdapUsersSearchObject
          165. LicenseCountObject
          166. ListData
          167. MSOlapProperties
          168. MapColorChip
          169. MapColorDropZone
          170. MapColorHierarchyChip
          171. MapColorMeasureChip
          172. MapDetailsDropZone
          173. MapDetailsHierarchyChip
          174. MapFilterDropZone
          175. MapFilterHierarchyChip
          176. MapLocationChip
          177. MapLocationDropZone
          178. MapLocationHierarchyChip
          179. MapLocationMeasureChip
          180. MapMotionDropZone
          181. MapMotionHierarchyChip
          182. MapSizeDropZone
          183. MapSizeMeasureChip
          184. MapTooltipChip
          185. MapTooltipDropZone
          186. MapTooltipHierarchyChip
          187. MapTooltipMeasureChip
          188. MapVisual
          189. MasterFlowExecutionPathElement
          190. MasterFlowFindDataSourceObject
          191. MasterFlowModelNameObject
          192. MasterFlowOtherObject
          193. MasterFlowProgressLogItem
          194. MasterFlowProgressLogRequest
          195. MasterFlowProgressResult
          196. MasterFlowSchemasObject
          197. MasterFlowSourceConnectionObject
          198. MasterFlowSourceObject
          199. MasterFlowTargetConnectionObject
          200. MasterFlowTargetObject
          201. MasterFlowUpdatedVariableResult
          202. MasterFlowValidationResult
          203. MasterFlowVariableConnectionObject
          204. MasterFlowVariableObject
          205. MasterFlowVariableValueObject
          206. MasterFlowVariablesResult
          207. MasterFlowVariablesValueObject
          208. MaterializedApiObject
          209. MaterializedItemObject
          210. MeasureGroup
          211. MeasureOverlayData
          212. MeasureOverlayToDeleteData
          213. MemberDataApi
          214. MembersSecurity
          215. MembersSecurityApiObject
          216. MetaDataTranslation
          217. ModelDataCatalog
          218. ModelDataFlowSourceInfo
          219. ModelProcessDateObject
          220. ModelProcessDateResult
          221. ModelRecognitionObject
          222. ModelScheduleOnDemandObject
          223. ModelScheduleOnDemandResult
          224. ModelSyncColumnsSettings
          225. ModelingAggregationMapping
          226. ModelingColumn
          227. ModelingConfigTranslation
          228. ModelingFolderTranslations
          229. ModelingHierarchy
          230. ModelingHierarchyLevel
          231. ModelingMeasure
          232. ModelingModel
          233. ModelingProperty
          234. ModelingRelationship
          235. ModelingRelationshipColumnPair
          236. ModelingServerInfo
          237. ModelingTable
          238. ModelingTranslation
          239. ModifiedItemsResult
          240. ModifiedUsersResult
          241. NewFolderApiData
          242. NlpQueryExportData
          243. NotificationIndicatorsRequest
          244. NotificationIndicatorsResult
          245. OauthDataSourceSettings
          246. OdbcDirectQueryOptions
          247. PieApiObject
          248. ProPermissions
          249. ProProfileApiData
          250. ProfileApiData
          251. ProfilePermissionHolder
          252. ProfileRolesData
          253. PulseClientData
          254. PyramidContentItem
          255. PyramidItemIdentifier
          256. PyramidUserObject
          257. PyramidViewUserObject
          258. QueryExportData
          259. QueryOptions
          260. QueryTotalSettings
          261. RelatedItemData
          262. RenameItemApiData
          263. RoleAdGroupsModifyObject
          264. RoleData
          265. RoleGroupModifyObject
          266. RoleMinimalData
          267. RoleToItemApiData
          268. RolesInItemRemovalObject
          269. ScatterColorChip
          270. ScatterColorDropZone
          271. ScatterColorHierarchyChip
          272. ScatterColorMeasureChip
          273. ScatterDetailsDropZone
          274. ScatterDetailsHierarchyChip
          275. ScatterFilterChip
          276. ScatterFilterDropZone
          277. ScatterFilterHierarchyChip
          278. ScatterFilterValuesChip
          279. ScatterLabelsChip
          280. ScatterLabelsDropZone
          281. ScatterLabelsHierarchyChip
          282. ScatterLabelsMeasureChip
          283. ScatterMotionDropZone
          284. ScatterMotionHierarchyChip
          285. ScatterShapeChip
          286. ScatterShapeDropZone
          287. ScatterShapeHierarchyChip
          288. ScatterShapeMeasureChip
          289. ScatterSizeDropZone
          290. ScatterSizeMeasureChip
          291. ScatterTooltipChip
          292. ScatterTooltipDropZone
          293. ScatterTooltipHierarchyChip
          294. ScatterTooltipMeasureChip
          295. ScatterTrellisHorizontalChip
          296. ScatterTrellisHorizontalDropZone
          297. ScatterTrellisHorizontalHierarchyChip
          298. ScatterTrellisHorizontalValuesChip
          299. ScatterTrellisVerticalChip
          300. ScatterTrellisVerticalDropZone
          301. ScatterTrellisVerticalHierarchyChip
          302. ScatterTrellisVerticalValuesChip
          303. ScatterVisual
          304. ScatterXValuesDropZone
          305. ScatterXValuesMeasureChip
          306. ScatterYValuesDropZone
          307. ScatterYValuesMeasureChip
          308. ScheduleSearchCriteria
          309. ScheduleViewObject
          310. ScientistPermissions
          311. ScientistProfileApiData
          312. SearchAdGroupUsersData
          313. SearchAdUserGroupsData
          314. SearchCriteria
          315. SegmentColorChip
          316. SegmentColorDropZone
          317. SegmentColorHierarchyChip
          318. SegmentColorMeasureChip
          319. SegmentDetailsDropZone
          320. SegmentDetailsHierarchyChip
          321. SegmentFilterChip
          322. SegmentFilterDropZone
          323. SegmentFilterHierarchyChip
          324. SegmentFilterValuesChip
          325. SegmentLabelsChip
          326. SegmentLabelsDropZone
          327. SegmentLabelsHierarchyChip
          328. SegmentLabelsMeasureChip
          329. SegmentMotionDropZone
          330. SegmentMotionHierarchyChip
          331. SegmentSizeDropZone
          332. SegmentSizeMeasureChip
          333. SegmentTooltipChip
          334. SegmentTooltipDropZone
          335. SegmentTooltipHierarchyChip
          336. SegmentTooltipMeasureChip
          337. SegmentTrellisHorizontalChip
          338. SegmentTrellisHorizontalDropZone
          339. SegmentTrellisHorizontalHierarchyChip
          340. SegmentTrellisHorizontalValuesChip
          341. SegmentTrellisVerticalChip
          342. SegmentTrellisVerticalDropZone
          343. SegmentTrellisVerticalHierarchyChip
          344. SegmentTrellisVerticalValuesChip
          345. SegmentValuesDropZone
          346. SegmentValuesMeasureChip
          347. SegmentVisual
          348. ServerData
          349. ServerMetrics
          350. SimpleModifierResult
          351. TabularColorChip
          352. TabularColorDropZone
          353. TabularColorHierarchyChip
          354. TabularColorMeasureChip
          355. TabularColsChip
          356. TabularColsDropZone
          357. TabularColsHierarchyChip
          358. TabularColsMeasureChip
          359. TabularFilterDropZone
          360. TabularFilterHierarchyChip
          361. TabularSizeDropZone
          362. TabularSizeMeasureChip
          363. TabularTooltipChip
          364. TabularTooltipDropZone
          365. TabularTooltipHierarchyChip
          366. TabularTooltipMeasureChip
          367. TabularVisual
          368. TagData
          369. TagUsageApiData
          370. TargetParameter
          371. TaskSummary
          372. TaskUserApiData
          373. TaskViewData
          374. TenantLicenseTypeData
          375. TenantObject
          376. TenantSettings
          377. TenantUsersGetObject
          378. ThemeApiObject
          379. ThemeListObject
          380. ThemeToItemsApiObject
          381. TogglePauseDatasourceApiData
          382. ToggleUserApiData
          383. TotalsSettings
          384. UpdateRoleData
          385. UpdateTenantSeatsObject
          386. UpdateUserAdObject
          387. UpdateUserDbObject
          388. UpdateUserFromSearchObject
          389. UpdateUserObject
          390. UpdateUserOpenIdObject
          391. UpdateUserSamlObject
          392. UserCredentials
          393. UserOpenIdCredentials
          394. UserPhone
          395. UserRolesData
          396. UserSamlCredentials
          397. UserTokenCredentials
          398. ViewerPermissions
          399. ViewerProfileApiData
          400. Visuals
          401. XtenderDataServer
          402. XtenderDatabase
          403. XtenderTenantDatabase
          404. XtenderTenantServer
        2. API Enumeration Definitions
          1. AccessType
          2. AdminType
          3. AggregationType
          4. AnalystPermissionOptions
          5. ApiResponseFormat
          6. AxisTotalsType
          7. BulkWritingType
          8. BwDatabaseListType
          9. BwInfoAreaTreeViewType
          10. CartesianBarVisualType
          11. CartesianColumnVisualType
          12. CartesianLineVisualType
          13. CartesianStackedBarVisualType
          14. CartesianStackedColumnVisualType
          15. CartesianVisualType
          16. ClashDefaultOption
          17. ClientLicenseType
          18. ColorMathFunction
          19. ConditionConjunctionType
          20. ConnectionStringType
          21. ContentItemObject
          22. ContentType
          23. ContentTypeObject
          24. CsvDelimiter
          25. CubeAuthMethod
          26. CustomRootCAType
          27. DataFlowModelType
          28. DataType
          29. DomainAdminPermissionType
          30. ElementSelectionDataType
          31. EtlProcessStatus
          32. EtlSyncModelColumnsType
          33. ExternalSearchType
          34. FilterHierarchyType
          35. FilterValuesType
          36. FirstWorkday
          37. FtpDataMode
          38. FtpSecurityType
          39. GaType
          40. GridColorOption
          41. HideMemberType
          42. HierarchyCategory
          43. HierarchyOverlayProperty
          44. HierarchyType
          45. IsolationMode
          46. ItemType
          47. JoinType
          48. KpiAttributeType
          49. LanguageType
          50. LdapSearchType
          51. LicenseStatus
          52. MapVisualType
          53. MaskingMethodType
          54. MaterializedItemType
          55. MeasureFormat
          56. MeasureMapOptions
          57. MeasureOverlayProperty
          58. ModelAttributeType
          59. ModelingColumnCategories
          60. ModelingColumnType
          61. ModelingTableType
          62. MsOlapConnectionType
          63. NonNumericQueryTechniqueType
          64. OpenIdAuthType
          65. OpenIdResponseType
          66. OperatorType
          67. PaperType
          68. ParentChildOrphans
          69. ParentChildRollupType
          70. PermissionBitIndex
          71. PrintingOutputType
          72. ProPermissionOptions
          73. QueryCacheMode
          74. QueryTotalPosition
          75. RoleAssignment
          76. RoleAssignmentType
          77. RootFolderType
          78. SapBwServerConnectionType
          79. ScatterVisualType
          80. ScheduleDataType
          81. ScheduleStatus
          82. ScheduleType
          83. ScientistPermissionOptions
          84. SearchMatchType
          85. SearchRootFolderType
          86. SecurityType
          87. SegmentVisualType
          88. ServerAuthenticationMethod
          89. ServerEffectiveUserName
          90. ServiceStatus
          91. SizeDropZoneOptions
          92. SizeMathFunction
          93. SparkTransportMode
          94. SyntaxType
          95. TagType
          96. TaskStatus
          97. TenantSwappingType
          98. UpdateSchemaValidation
          99. UserProfileType
          100. UserStatus
          101. ValidRootFolderType
          102. ValuesDropZoneOptions
          103. VariableType
          104. ViewerPermissionOptions
    2. Custom Visual API
      1. Custom Visual APIs 2.0
        1. Getting Started with the CV API
          1. Custom Visual Example - Aster Plot
        2. CvApi2
          1. Canvas
            1. Style
          2. ResultSet
            1. Data
              1. TrellisData
                1. Datapoint
                  1. Numerics
                    1. Value
            2. Dropzone
              1. Chip
                1. Element
          3. VisualConfig
          4. Utils
          5. ExternalLibraries
            1. D3Libraries
            2. UtilsLibraries
          6. Enums
            1. ChipType
            2. ColorRangeType
            3. DropZoneType
            4. Event
    3. Custom WorkFlow API
      1. Using the WorkFlow API
        1. Custom Workflow API Example
      2. Workflow API Overview
      3. WorkflowApi
        1. Canvas
        2. WorkflowThread
          1. Entry
            1. Attachment
          2. Contact
        3. Session
        4. Utilities
        5. ExternalLibraries
        6. Enums
          1. AttachmentType
          2. ContactType
          3. ThemeType
          4. WorkflowThreadType

Video Tutorials

  1. Pro Videos
    1. Model Videos
    2. Discover Videos
      1. Videos about Discover Visuals
      2. Discover Analytics Videos
    3. Present Videos
    4. Publish Videos
    5. Formulate Videos
    6. Tabulate Tutorial Videos
    7. Illustrate Videos
    8. Content Manager Videos
    9. Admin Videos
  2. Analyst Videos
  3. Viewer Videos

Pyramid Analytics © 2017-2025